MySql database

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!

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

Help!!!

explain more

command line...

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.

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

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

Something similar to:

Code:

---

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.

OK GOOD!!!!!


Thanks Much!!


time to play


- kurt simons