remote mysql database access questions

[shilmy]

Hi All,

This seems to be a simple question, but I cannot find the answer after looking on google and yahoo search.

Most of php scripts that use mysql database use localhost as their server. If my database is on other server, can I access the database using php scripts? How?

Thanks in advance for any info.

Regards,
Sjarief

[danlefree]

The PHP mysql_connect() command should cover everything for you - just include the domain name or IP address of your MySQL server and you're set.

Check out the PHP mysql_connect() Manual for detailed information and code samples.

[node-net]

Where it says 'localhost' replace it with 'www.yourcompany.com' or the 'IP address' of the MySQL host computer.

Good look.

Dreamweaver handles PHP connections well. (Although it is a bit meagre on other controls.)

[shilmy]

Where it says 'localhost' replace it with 'www.yourcompany.com' or the 'IP address' of the MySQL host computer.

Good look.

Dreamweaver handles PHP connections well. (Although it is a bit meagre on other controls.)

Thanks, it works now...