Remote access to MySQL database

[bladx]

Hi, I have a mysql database on one computer, and it is at a specific ip location. I have read through a lot of the other articles here related to connecting to remote mysql db's. I still don'tknow how to do this. What I need to be able to do is to connect to this server from another server, and display results from a given database using PHP. Is there a way to do this? Right now, when I try it, it is just hanging ... it is just a blank screen. It seems to be working, but never finishes. Any help is appreciated.

[edwardsbc]

How are you connecting to the remote database?

You need to make sure the MySQL database is properly configured to actually listen for connections from non-localhost servers. By default, I don't believe it does. Make sure you are using the correct TCP port (3306 by default) and that the requesting machine has a proper user account credentials (both on the MySQL database and for any firewall on the MySQL machine (if any)).

<http://www.php.net/manual/en/function.mysql-connect.php>

<http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html>

[gerardg]

Just add a user and specify the host.