How to Enable Remote MySQL in the Domain cPanel Interface?

• 11 October 2021
• in: MySQL

In cPanel servers, remote MySQL connections are disabled by default as they’re considered as a potential security threat. it’s possible to add remote hosts with the help of tools within the domain-level cPanel interface that the server permits to connect to the MySQL service.

Prior to using the subsequent technique, you’ll have to be compelled to open up port 3306 in your server’s firewall

Let’s see the steps to Enable Remote MySQL within the Domain cPanel Interface

1. Log in to the interface of the domain’s cPanel and look for the section of Databases on the main page.

2. Then in the Databases section, search for the Remote MySQL link/button and click on it.

3. you’ll see the below page in your browser. Next, add an IP address or hostname to that you would like to permit remote MySQL access to (1) and so click on the Save button (2).

4. If an IP address or host needs to be removed from this list, then you’ll click on the ‘Delete’ button simply next to the entry within the list.

5. After all the changes, additions or removals are done to the list, you’ll return to the main page of the cPanel interface or logout, if you’ve completed alternative tasks.

Thus by following the above steps you can enable remote MySQL in the domain cPanel interface.