How to Set Up Remote MySQL Access on cPanel?

Setting up remote MySQL access allows you to connect to your database from a different server or computer. Here’s how to do it through cPanel:

Step 1: Log in to cPanel

1. Open Your Web Browser:
• Navigate to your cPanel URL (e.g., https://yourdomain.com/cpanel).
2. Enter Your Credentials:
• Log in using your cPanel username and password.

Step 2: Locate the Remote MySQL Tool

1. Find the Databases Section:
• In the cPanel dashboard, scroll down to the "Databases" section.
2. Click on Remote MySQL:
• Select the "Remote MySQL" icon. This section allows you to manage remote access to your MySQL databases.

Step 3: Add Remote Host

1. Add Hostname or IP Address:
• In the "Add Access Host" field, enter the hostname or IP address of the remote server that needs access.
• You can also use % to allow access from any host (not recommended for security reasons).
2. Click on Add Host:
• After entering the details, click the "Add Host" button.

Step 4: Verify Access

1. Confirmation Message:
• You should see a confirmation message indicating that the host was added successfully.
2. Note Your Database Details:
• Take note of your MySQL username, password, database name, and the server's IP address for connection purposes.

Step 5: Connect to the Database Remotely

1. Use a MySQL Client:
• You can connect to your MySQL database using any MySQL client (like MySQL Workbench, phpMyAdmin, or command-line tools).
2. Connection Details:
• When prompted, enter the following details:
• Host: Your server’s IP address or domain name.
• Username: Your MySQL username.
• Password: Your MySQL password.
• Database: The name of the database you want to access.

Conclusion

Setting up remote MySQL access in cPanel is a straightforward process that enhances your ability to manage databases from different locations. By following these steps, you can enable remote connections securely. Always remember to limit access to specific IPs to enhance security!