remote access w/ php & mySQL

[Anon]

i have a mysql server on a different computer from my webserver, and i would like to use php to do database queries, etc. so to test the connection, i made a php file with the code
i have MySQL on 10.0.0.12 and apache on 10.0.0.11

<?php
$db = mysql_connect("10.0.0.12", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
printf("Address: %s<br>\n", mysql_result($result,0,"address"));
printf("Position: %s<br>\n", mysql_result($result,0,"position"));
?>

yes, the database works, and I can use the MySQL program on 10.0.0.12 to execute this query. but when viewed in a browser, the page shows this error:

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

how do i enable 10.0.0.11 to remotely access the MySQL server?

[Anon]

I am assuming you are sending this thing a password?

$db = mysql_connect("10.0.0.12","root","password");

if that dont do it run a port scanner to see if mysqld is running on anyport

(3306 is default)

if not look in your config file (for me its /etc/mysql/my.cnf) and take out the line that says:

skip networking

Hope this Helps!

[Anon]

ok... i can't find a my.cnf on my computer. find / | grep my.cnf returns nothing... maybe this is my problem? i'm running MySQL 3.23.49a-1 on redhat linux 7.2, if that helps. thanks.

[mithril]

Check your user permissions on the database in question. You need to have a given permission for the user to connect from 10.10.10.11 (or any host) in order to connect to to the redhat box. Read the MySQL Manual section on the GRANT statement for more info.

-geoff

[Anon]

hey
I found my.cnf at the following location ..so check it if /etc/my.cnf exists