Knowledge Base

How to Set Up a Remote MySQL Database Connection in cPanel

Access Remote MySQL in cPanel

  1. Log in to your Thamara Cloud cPanel.

  2. Scroll down to the Databases section.

  3. Click Remote MySQL®.

 

Add a Remote Access Host

  1. In the Add Access Host field, enter the IP address of the server or computer you want to allow access from.

    • Example: 123.123.12.123

    • You can use a wildcard (e.g., 192.168.0.%) to allow a range of IPs, but only if you trust those sources.

  2. Optionally, add a short note in the Comment field for reference.

  3. Click Add Host to apply changes.

 

Manage or Remove Access Hosts

To edit or remove existing IPs:

  • Navigate to the Manage Access Hosts section.

  • Click Update to edit or Delete to remove an IP from the list.

This ensures you maintain control over which devices can access your databases.

 

Connect to the Database Remotely

Once the IP is added, connect to your database using your preferred MySQL client with the following details:

Setting Value
Host Name Your Thamara Cloud server IP
Database Name cpanelUsername_databaseName
Username cpanelUsername_databaseUser
Password Your database user password
Port 3306

If you encounter connection issues, verify that:

  • The correct IP address is whitelisted

  • The username and password are correct

  • Port 3306 is open on your local network

 

Please rate this article to help us improve our Knowledge Base.

0 0