Remote Connection to MySQL Server

[Anon]

How do I connect to a remote MySQL Server? What do I replace "localhost" with? Thanks.

[Anon]

Neil Moomey wrote:

How do I connect to a remote MySQL Server? What do I replace "localhost" with? Thanks.

---

The IP address or the fully qualified domain name of the machine running the MySQL server. Be sure that your permissions are set correctly (i.e. the mysql server needs to be configured to allow your user to connect to it from the machine your script is running on). For info about how to configure permissions correctly, read the mysql manual (online at mysql.com)

[Anon]

Hi Mate,

First of all you need to make sure that the user has rights to the tables. so issue something like

GRANT ALL on <database>.* to <username>@% identified by '<password>'

This will then allow you to connect from anywhere using this id to the database in question.

Cheers

Ray