RE: [PHP-DB] MySQL connection problem - need help from expert

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 foo@localhost.localdomain has an account on that server 4: That foo's password is bar. HTH, Cal http://www.calevans.com -----Original Message----- From: Ian [mailto:hee@b163.com] Sent: Thursday, March 22, 2001 7:50 PM To: php-db@lists.php.net 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net