Greetings and Salutations Ian, Somewhere in your code you are going to have a line similar to this: $currentConnection = mysql_connect ($server, $userName,$password) $server is going to be either the name or the IP address of your server $userName is going to be the MySQL user name you use to connect to MySQL $password is going to be the password for your username. an example would be: $currentConnection = mysql_connect ('192.168.0.1', 'foo','bar'); This would create a connection to a MySQL server on 192.168.0.1 for user foo with password bar and store it in $currentConnection for you to use. This assumes that: 1: There IS a MySQL server on 192.168.0.1 2: That it is running on the standard port. (3306?) 3: That [EMAIL PROTECTED] has an account on that server 4: That foo's password is bar. HTH, Cal http://www.calevans.com -----Original Message----- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 7:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL connection problem - need help from expert Please help me !!! Description :- Server 1 is installed MySQL which located in US. Server 2 is located in Singapore, and doesn't install Mysql. Both of them are installed PHP and Acaphe. Case:- I would like to set the server 2 connect to Server 1's MySQL database. What should I do? Thank you in advance. Ian. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]