In this post we explain how to setup a remote MySQL connection in cPanel.
This tutorial is for customers on the Pickaweb hosting plan.
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@example.com 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.
I hope you found this information useful on how to setup a remote MySQL connection in cPanel.
Thanks for reading and leave your questions below to keep the conversation going.