How to Connect Remotely to Your MySQL Database in cPanel Print

Connecting remotely to your MySQL database allows you to manage your database from a remote location using various database management tools. Follow these steps to set up remote access to your MySQL database in cPanel.

NOTE: Before you begin, you'll want to make sure the database has been created and you've added a database user with the appropriate permissions in your control panel (cPanel). You'll also need to submit a ticket and let us know which IP address you'll be connecting from.

Step-by-Step Guide:

1. Log in to your cPanel account:

   • Open your web browser and navigate to your cPanel login page.
   • Enter your username and password to access the cPanel dashboard.

2. Navigate to the Remote MySQL feature:

   • In the cPanel dashboard, scroll down to the "Databases" section.
   • Click on the "Remote MySQL" icon.

3. Add Access Host:

   • In the "Remote MySQL" page, you will see a field labeled "Add Access Host."
   • Enter the IP address of the computer that will access the MySQL database remotely. This is the IP address you are connecting from.
   • Click the "Add Host" button to allow access from the specified IP address.

4. Verify the database user and permissions:

   • Ensure that the database user you plan to use for remote access has the necessary permissions for the database. You can manage database users and permissions in the "MySQL Databases" section of cPanel.

5. Obtain MySQL connection details:

   • Gather the following information needed to connect remotely to your MySQL database:
     • Hostname: Your domain name or the server's IP address.
     • Database Name: The name of the database you want to connect to.
     • Database Username: The username with access to the database.
     • Database Password: The password for the database user.
     • Port: The port number MySQL is running on (default is 3306).

6. Connect to your MySQL database remotely:

   • Use a MySQL client or management tool (e.g., MySQL Workbench, phpMyAdmin, HeidiSQL) to connect to your MySQL database.
   • Enter the connection details you gathered in the previous step to establish a connection.

Additional Information:

• Security Considerations: Only allow access from trusted IP addresses to ensure the security of your database.
• Database Management: Use secure connections (SSL) when connecting to your database remotely to protect your data.

Troubleshooting:

• Connection Issues: If you are unable to connect, double-check the IP address you added in the "Remote MySQL" section and ensure it matches your current IP address.
• User Permissions: Verify that the database user has the correct permissions to access the database remotely.

If you have any issues connecting remotely to your MySQL database, please don't hesitate to contact our support department for assistance or refer to the official cPanel documentation.

Looking for reliable Linux hosting with Award Winning Customer Support?
Grab your hosting today with a 20% discount. All plans come with our 60 Money Back Guarantee!

Check out our plans & promotions on our website -- https://www.peopleshost.com/