Within cPanel, clients are able to set up their MySQL database to grant remote hosts to access the account. This feature is great for those looking to allow other applications to access the database for content. This guide will walk you through how to delegate access, but before that, please note:
We do not open the MySQL port by default to everyone, the steps performed here will need to be done plus a ticket will be required to allow the remote access to the IP connecting to the MySQL server.
We do not allow shared / reseller MySQL servers to be used as a remote MySQL server, the usage has to be strictly for database maintenance/testing purposes, any excessive usage will cause access to be revoked.
It is highly advised NOT to add % as a host as this means ALL hosts are allowed to make connection attempts. In order for BigScoots to allow the connection through the firewall, an IP address is needed.
Please follow the steps below to configure remote MySQL access:
Enter cPanel - If you don't know how, you can follow this guide.
Under the Databases section click on Remote Database Access.
Add the remote locations IP and/or hostname. This will be the IP/hostname of the client connecting to the MySQL server. Its usually best to add both the IP and the hostname to prevent MySQL blocking access. You can also add a comment, though it is optional. Once finished, click Add Host.
You will receive confirmation like below that says the host was successfully added.
Now back on the Remote Database Access section, you will see the Access Host in the table below. Here you can remove the host and update the comment.
Congratulations! You've successfully set up remote access to the MySQL database.
If you have any questions, please don’t hesitate to contact our team via live chat.
For technical inquiries, please feel free to reach our support team by emailing support@bigscoots.com from your registered email or by submitting a support ticket.