PHP===>conencting to the mysql server?

Question

How can i connect to a database located in another server.
(***code plz***)

Answer 1

In mysql_connect function, you will have to provide the ip address of that system where mysql is running. But your user must be allowed to access mysql database from the server where php is running.
I mean, if ur webserver (Apache/IIS) is 192.168.0.1 and your mysql is 192.168.0.2 and ur user is "test". This test must be allowed in "user" table of database "mysql" so that this can access the database on 192.168.0.2 from 192.168.0.1.

Answer 2

// Connects to a different Server Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
?>