cPanel allows you to enable remote access to MySQL databases, which means external applications or developers can connect to your database from another server or local machine.
To ensure security, only specific IP addresses must be whitelisted before access is granted.
Enable Remote MySQL Access in cPanel
Follow these steps to allow remote connections:
-
Log in to cPanel
Access your hosting control panel using your credentials. -
Open Remote MySQL Tool
Navigate to the Databases section and click Remote MySQL®.
-
Add an Access Host (IP Address)
-
In the Add Access Host field, enter the IP address you want to allow.
-
Click Add Host to whitelist it.
Tip:
-
- You can find your IP using tools like ip4.me.
- If a developer needs access, ask them to provide their IP address.
-
Manage Allowed Hosts
-
All added IPs will appear in a list below.
-
You can remove any IP address at any time.
-
Important Security Notes
-
Avoid using the wildcard symbol
%to allow all IPs. While it works, it exposes your database to serious security risks. -
Only grant access to trusted IP addresses.
-
For advanced permissions or configurations, contact your hosting provider.
Connect Remotely Using MySQL Workbench
Once remote access is enabled, you can connect using tools like MySQL Workbench.
Steps to Connect:
-
Open MySQL Workbench.
-
Click New Connection.
-
Enter the following details:
-
Connection Name: Any name you prefer
-
Connection Method: Standard (TCP/IP)
-
Hostname: Your domain name or server IP
-
Port: 3306
-
Username: Database user
-
Password: Database user password
-
Default Schema: Optional
-
Click Test Connection.
-
If successful, save the connection.
-
Open the connection to start managing your database.
Summary
-
Use Remote MySQL® in cPanel to allow external access.
-
Whitelist only trusted IP addresses for security.
-
Connect using tools like MySQL Workbench for database management.
