In this guide, we will provide you with detailed instructions on how to establish a remote connection to your MySQL databases through the cPanel control panel, eliminating the need to access the server directly.
Steps to enable remote access to MySQL:
1. Access cPanel:
Enter your cPanel URL (for example, [yourdomain.com/cpanel])
Enter your cPanel username and password.
2. Select "Remote MySQL":
You will find this option within the "Databases" section.
3. Add Remote Access Hosts:
On the Remote MySQL page, enter the remote host name or IP from which you want to establish the connection to the database (it can be a domain, an IP or even an IP range).
Click on "Add Host" to allow access from that location.
You can use the character "%" as a wildcard to allow access from specific IP addresses (for example, 104.17.43.%).
Once we have added the access, we will be able to view it in the lower section, where we are given the option to update the comment or delete the host.
4. Configure the connection in your database management software:
Open your database management software.
Create a new MySQL connection.
Enter the following information:
Server: The IP address or domain name of your cPanel, usually found on the right side of your control interface, as shown below in the cPanel control panel:
Port: 3306 (default MySQL port)
User: The username associated with the database. Note: Make sure you have correctly linked the user to the database and assigned permissions.
Password: The password corresponding to the database user.
Database: Name of the database you wish to connect to.
5. Test the connection:
Click on "Connect" or "Test Connection".
If the connection is successful, you will see a confirmation message.
If the connection fails, review the configuration information and make sure there are no errors.
Conclusion:
With this guide, you will be able to enable remote access to MySQL in your cPanel account, configure the connection in your database management software and perform tests to ensure a successful connection.
If you encounter any difficulty or have any questions, do not hesitate to contact our technical support team through the email address [email protected] or via live chat from your client area for additional assistance.