Connecting to remote mysql server

Question

I use this to connect to my local mysql server:

<?
$host = "localhost";
$user = "root";
$pass = "";
$db1 = "mydb";
$db = mysql_connect($host,$user,$pass);
mysql_select_db($db1,$db);
?>

But, I want to connect to a remote mysql server instead. I mean that site will be on the same server, but I'll connect to another mysql server. How can I do this?

I'm on Ubuntu.

Answer 1

This is as simple as adjusting $host, $user and $pass appropriately. Of course, firewalls between you and the remote server will have to allow the connection, and you'll need a valid username/password (which should not be "").

Answer 2

On the remote MySQL server issue a GRANT statement like:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON mydb.* TO remoteuser@'192.168.1.10' IDENTIFIED BY 'password';

Then change your $host to the remote MySQL server's IP address and $user to remoteuser and $pass to password (but hopefully not password). Also make sure that the remote MySQL server doesn't have bind-address=127.0.0.1 in the my.cnf and that there aren't any firewall rules blocking access.

In the above GRANT statement 192.168.1.10 is the IP address of the host that is running your PHP application.

Hope this helps.