In the 'user' table in the 'mysql' database on server1, you need to insert the username you'll be using to connect (and the encrypted password), and in the Host field you have to specify the hostname of server2, as well as what privileges you want that user to have (I recommend nnnnnnnnnnnnnn, then specify in the db table which database the user is allowed to connect to and what he can do to it). Then flush privileges, and you're set. Of course, you'll have to have root access to the mysql server to make these changes. Cheers, Thor. PS. As much as I hate to use the RTFM quote (the 'rtfm' reply rubs me the wrong way and is one of the biggest deterrents for new users of GPL software, most people ask because they can't find the info, so rtfm is unecessarily rude), I'll bet you this is explained in better detail in the mysql documentation. So, I won't actually say it, but merely imply it... > -----Original Message----- > From: Ian [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 22, 2001 5: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]
