Enabling MySQL remote connections

Remote MySQL connections are disabled by default in cPanel servers because they are considered a potential security threat. Using the tools in the Web Host Manager (WHM) and the domain-level cPanel interface (usually http://domainname.com/cpanel) remote hosts can be added which the server allows to connect to the MySQL service.

Enabling Remote MySQL in the Domain cPanel Interface

Log in to the domain’s cPanel interface and find the section on the main page labeled Databases.
In the Databases section find the link/button labeled Remote MySQL and click on it.
Add a hostname or IP address that you want to grant remote MySQL access to and then click the Save button

If a host or IP address needs to be removed from this list you can click the ‘Delete’ button next to the entry in the list.

Once you have made your changes, additions, or removals to the list you can return the main page of the cPanel interface, or log out if you have no other tasks to take care of.

Important: Our provider reserves the right to block all inbound MySQL connections in order to prevent attacks to the mysqld service. If you are unable to connect, please contact support so that we can get your IP address added to our whitelist.

Leave a Reply

Your email address will not be published. Required fields are marked *

Need Help On A Project?

Contact us today with your query and we’ll see if we can help you get the gears rolling.