cannot connect to mysql

[Anon]

Hi, I want to ask how I can connect to mysql?
but my php script is in domain A, but my mysql database is in domain B, I have change the statement to:
mysql_pconnect("domain","root","")
but error occur:
Host 'domain' is not allowed to connect to this MySQL server.....

Can anyone tell me what wrong for my setting?

[infernalc]

Your problem may by ther permissions system on the MySQL server. Every MySQL server has a database named 'mysql' which has user and host permissions tables. When the server recieves an incoming connection request, be it from a mysql client or a php parser, it checks this database to verify that the incoming connection is permissable.

What you need to do is get the admin on the mysql server to issue a GRANT query using the mysqladmin program, allowing access for a user (*note, root is a bad username...) with a password from host B or whereever your php page resides. The MySQL manual explains this better than I can.

See chapter six of the manual, online at:

http://www.mysql.com/doc/P/r/Privilege_system.html

[plutarck]

Check the permissions for the username and pass you are using to connect to the database.

View SQL manual chapter 6.13 for what I mean.

For instance if you set up the name "User", most places only do:

GRANT ALL PRIVILEGES ON . TO
User@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

to give them full access. However, that middle line means you can access only through localhost.

If you are set up that way you'd need to do this:

GRANT ALL PRIVILEGES ON . TO
User@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

So you can access the database from any location.

I'm guessing that's the problem you're having, but I'm guessing the syntax is a little different for changing the settings of the root user.