Hey guys, I've spent two days on this and I'm out of ideas.
Here is my situation, I am trying to connect to a database from a PHP page that is not on the same box as the database.
so I do this:
$link=mysql_connect($dbHost, $user, $password);
if(! $link)
die("Could not connect to MySQL");
mysql_select_DB($database, $link)
or die ("Cound not open $database, $link: ".mysql_error());
then I get some records from the database and print them out.
All of this works fine if the PHP page is on the same box as the database and I have $dbHost set to be "localhost"
However when I move the php page to a different box and change the $dbHost var to be the ip of the box with the DB on it I get the following error:
Warning: Host 'myIPHere' is not allowed to connect to this MySQL server.
So its talking to the mySQL server and it finds the database. Somewhere I need to give it access. I'm assuming that I'm missing something in the my.cnf file, but I can't for the life of me figure out what it is.
Any ideas? Pppllleeeaassseee?
Thanks so much for the help!
-Jake