running PHP and MySQL on different boxes

[Anon]

Just curious, is there anyway to run you MySQL server and PHP package on different machines? If so how?

[[deleted]]

Silly question #245. 🙂

ofcourse it is possible, why do you think there is a 'hostname' in the mysql_connect function?

[ziggs]

HAHAHA. So would you like put the IP in there? Thats a honest question. Your saying that I could run my entire database off another computer? Haha.
Ziggs

[Anon]

It can be a lot slower, and often MySQL only accepts connections from localhost. But, in many cases you can put an IP or other form of host name for hostname. Of course you still need a valid username and password. If you could only connect to localhost, would a hostname really be necessary in that function?

[mikeq]

Just make sure the remote user (Webserver box) has privileges to the MySQL database.

so on the MySQL box at the MySQL command line type

grant all privileges on *.databasename to username@remoteipaddress identified by 'password';

Flush Privileges;

remoteipaddress would be the IP of the webserver.

Mike

[mikeq]

oops sorry should be databasename.*