Remotely Connect to a MySQL Database

Remote MySQL IconIt is possible to connect to your MySQL database remotely. First you will need to allow the IP address access, to do this click the Remote MySQL icon in cPanel.

Then enter the IP address or host you wish to allow in the Add Access Host section. % can be used as a wildcard, so the pre-existing entry of 192.168.1.% allows access from all IPs 192.168.1.0-999. Adding a host of just "%" will allow access to absolutely everyone (who knows the password) so this is not advised.

Now you can connect to the domain name on mysql's standard port using the MySQL username and password.

Was this answer helpful?

 Print this Article

Also Read

Error Log

We have disabled the error log function in cPanel because it contains a quirk that causes it not...

What is the server path?

Easy! /home/username/public_html Be sure to replace username with your cPanel Username.

How can I use PostgreSQL 9?

PostgreSQL 9.2 is available on some of our shared hosting servers, but not all. If you'd like to...

Email Hourly Limit

If you have sent a mass email (mailing list etc) and had emails returned with a message that your...

Setting up Python and Ruby apps

Please note: If you've previously set up a Django app using our old instructions, please see...