Developers sometimes need to connect to database from remote locations. Most often this is to allow a client program running in a remote computer to access the database hosted in the server.
In cPanel servers this is really easy and just a few simple steps to follow:
- Go to cPanel >> Databases >> Remote MySQL
- Add your workstation IP in the field Add Access Host
- Click on Add host
You can also delete an already added host IP from this same page.
We have not allowed the database port globally in our shared servers for obvious security issues. So we need to allow your IP in the firewall to be able to access MySQL port. For this, email us to [email protected] from your registered email address or submit a ticket from your billing area requesting the workstation IP to be whitelisted in the firewall. You may go to https://www.pickaweb.co.uk/ip/ for obtaining your workstation IP.