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
- Log in to cPanel.
- For help accessing your cPanel see Where do I log in to my hosting control panel.
- Click Remote MySQL.
- Enter the IP address you want to allow access to your MySQL databases into the Host field. For example, 10.0.0.1.
- Add a comment so you know what the IP address was for, for example, Office.
- Click Add Host.
- Wait one minute. We will automatically allow MySQL access through our firewalls for the IP addresses you have entered.
You can then connect remotely to your databases using the server hostname, your MySQL database user and MySQL password and port 3306.
- 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.