Connect to your MySQL database from a remote connection

If you have a MySQL database with your hosting account and need to connect to it from your home computer, or another web server, you'll need to add a remote "Access Host" to your database to allow the connection in.

Go to:

User Level -> MySQL Management -> databasename -> Add Access Host

You can either add the IP of the remote connecting box, or just use:

%

to allow any IP (if you're unsure of the remote IP, or if it may change)

Note that the correct login/password is still required, the Access Host is just another layer of security.

Also make sure that port 3306 is open in your firewall on the DirectAdmin box, so the remote box can connect.


Was this article helpful?

mood_bad Dislike 2
mood Like 0
visibility Views: 7459