How to Connect Remotely to MySQL

You can access and administer your MySQL databases on your Ecenica hosting service from remote locations. To access a MySQL database you’ll need to add your current IP address to the Remote MySQL Access list in cPanel.

How to set up remote MySQL access

1. Log in to cPanel.
   • For help accessing your cPanel see Where do I log in to my hosting control panel.
2. Click Remote MySQL.
3. Enter the IP address you want to allow access to your MySQL databases into the Host field. For example, 10.0.0.1.
4. Add a comment so you know what the IP address was for, for example, Office.
5. Click Add Host.
6. Wait one minute. We will automatically allow MySQL access through our firewalls for the IP addresses you have entered.

Connecting to your Remote MySQL

You can now connect remotely to your databases.

For your database host;

• Server hostname. For example server.example.com
• Server IP address. For example 10.10.10.10
• A domain name connected to your Ecenica hosting. E.g example.co.uk

Enter your MySQL database user, MySQL password and port as 3306.

Notes

• Only IP addresses are supported.
• Hostnames added to the Hosts in cPanel will not work.
• Wildcards (%) for the last part of your IP address are accepted. For example. 10.0.0.%
• For security, we do not allow complete wildcard (%) access to your MySQL databases.
• We recommend accessing your MySQL databases via a SSH tunnel as it is more secure.
• If you have a dynamic IP address which changes we recommend you access your MySQL databases via a SSH tunnel.