[mysql server connection problem]

well with reagrds to phpbb not being able to access the DB you need to assign a username and pass to the blank DB you create.

 

i used the mysql_setpermission program and then phpbb worked fine!!!

 

i just want to be able to administor a DB from a windows environment

 

G

[mysql server connection problem]

lol

 

i shagged 4 installations doing that. came to the conclusion not to mess with the password on RH

 

i\'ve got another machine so i\'m going to play with that first!

[mysql server connection problem]

Hi,

 

I\'m using the mysql windows program on windows 2000 to access my linux\'s mysql database on RH9. when i try to connect i get a:

 

[custard] ERROR 1130: Host \'w2k.cream-cake.com\' is not allowed to connect to this MySQL server

 

now i see a few posts mentioning GRANT tables and setting permissions but i\'m using RH9 and i dont need a password to enter mysql, i just press enter. i tried setting permissions on test databases in the past this way and screwed mysql right up! it wouldnt even let me access it from the localhost (on linux) kept saying access denied ! and this was for root!!!! i dont want to set a password as i\'m happy having it open...

 

i need a way to allow my windows host (w2k.cream-cake.com) to access the DB on RH 9 without screwing up mysql?

 

thanks

[MySQL Databases]

i got it working by the way

[MySQL Databases]

i\'m learning them all!

 

as sql...well i log in as root and get straigh into mysql

 

create a database but phpbb2 cant access it....

 

i\'m lost!

[MySQL Databases]

i just started the mysqld script...........?

 

sqladmin is part of that

[MySQL Databases]

i really dont know that much!

 

i\'d be glad to help you out though, two heads are better than one

 

i\'ve created a database by doing

 

sqladmin create database

 

but i need to add a username and password to it

 

i.e so i can start to install phpbb2 to it

 

thanks

[MySQL Databases]

this is the exact stage i\'ve got too....

 

i\'m hosting my own site on RH9 with apache and mysql

 

how do i create a blank database with a username and password so phpbb can write to it?

 

i tied the test database which doesnt have a password and phpbb went werid!

 

then i had problem accessing mysql at all! access denied messages!

 

lol....i\'ve just reinstalled and at stage 1 again.

 

any help welcome