How to Connect to the MySQL Database Remotely

By default, ALL IPs are blocked and must be added to an access list in order to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.

If you do not know your IP address, find it by going to http://ip.mysau.com.au/.

Log into cPanel.Under Databases, click the Remote MySQL icon.

In the Host field, type in the connecting IP address.Click Add Host.You should now be able to connect remotely to your database.

Removing an Access HostTo remove a host from accessing databases on your server, just click the "X" next to the listed IP address.