MySql database

[kurtsimons]

MySql is running on my linux box, but, i cannot connect to it from PHP.

also I telnet into port 3306 and it says
host 'linuxserver' is not allowed to connect the is MySql serverConnection


any help!

[parksie]

In your MySQL permissions table, does a remote user - host "%" - have permission to connect?

[kurtsimons]

Help!!!

explain more

command line...

[parksie]

Database: mysql
Table: user

Each of the items in that table is a user and a host, along with the permissions of what they can/can't do. You need to make sure that there is an entry for your username and host along with the permissions.

[kurtsimons]

Localhost is there with user root

my computer name is linuxserver
should it be there?

how can I add to this db.
I can't simple add a record because the password in encrypted.

how can I add a line that will allow anyone to access any db on my system if the connection comes from my computer

thanks

[parksie]

You can add a record via SQL using the PASSWORD('string') function.

Something similar to:

INSERT INTO user VALUES('%', 'username', PASSWORD('pass'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

Obviously change the permissions to what you want.

[kurtsimons]

OK GOOD!!!!!


Thanks Much!!


time to play


- kurt simons