php remote access

Anon

i've got a mysql database on one server and the webserver on another, so i'd like to use php to access the sql server, and it looks like it ought to, but when i do this:

mysql_connect("10.0.0.5", "root");

i get

Warning: Host '10.0.0.6' is not allowed to connect to this MySQL server in /usr/local/etc/apache/htdocs/random/sqltest.php on line 5

10.0.0.5 is my sql server and 10.0.0.6 is my webserver. any ideas?

Anon

Hello,

The default installation of MySQL server doesn't allow remote connections so you can modify its configuration trought the "mysql" database. It database contains some tables. The table to allow remote connectios is the table "hosts". You have to open it and add your WebHost to be allowed to make a remote connection.

bye

Anon

i logged into the sql server locally, opened up the mysql database, and typed

SELECT * FROM hosts;

just to get a feel for what's in there and how to edit it. however, this returns

ERROR 1146: Table 'mysql.hosts' doesn't exist

help?

Anon

Chapter 4 of the MySQL manual is a must-read, particularly the sections covering access control, the GRANT and REVOKE syntax, and the one covering "causes of access denied" errors. Read carefully; both the db and host tables are involved in the access control process for remote hosts.