For security reasons, cPanel servers disable remote MySQL connections by default. However, there may be instances where you need to enable this feature. This guide will walk you through the process of enabling remote MySQL connections using the Web Host Manager (WHM) and the domain-level cPanel interface.
Enabling Remote MySQL in the Domain cPanel Interface
- Log in to your domain's cPanel interface. You can usually access this by navigating to http://domainname.com/cpanel.
- On the main page, locate the section labeled 'Databases'.
- Within the 'Databases' section, find and click on the link or button labeled 'Remote MySQL'.
- Enter the hostname or IP address that you want to grant remote MySQL access to, then click the 'Save' button.
- If you need to remove a host or IP address from this list, simply click the 'Delete' button next to the corresponding entry.
- Once you've made your changes, you can return to the main page of the cPanel interface or log out if you've completed your tasks.
Please note that we reserve the right to block all inbound MySQL connections to prevent attacks on the mysqld service. If you're unable to connect, please contact our support team so we can add your IP address to our whitelist.
By following these steps, you can enable remote MySQL connections in your cPanel interface, allowing specified hosts to connect to your MySQL service.