How to Configure Remote MySQL Access in cPanel
Remote MySQL access is an important feature in web hosting that allows external applications, websites, or servers to connect to your database hosted on a server. By default, MySQL in cPanel only allows local connections for security reasons. However, in many real-world scenarios—such as connecting a remote website, application, or analytics tool—you need to enable remote access.
In this guide, you will learn how to configure Remote MySQL access in cPanel safely and correctly.
What is Remote MySQL Access?
Remote MySQL access allows a database hosted on one server to be accessed from another server or IP address.
For example:
- Your website is hosted on Server A
- Your application is running on Server B
- You want both systems to share the same database
To make this work, you must allow Server B’s IP in your cPanel MySQL Remote Access settings.
Why Do You Need Remote MySQL Access?
You may need it for:
- Connecting external applications to your database
- Multi-server hosting architecture
- Mobile apps accessing web databases
- Reporting tools and analytics systems
- Development and staging environments
Step 1: Login to cPanel from Client Area
First, login to your client area account.
After logging in:
- Go to Services
- Click on My Services
- Select your active hosting service
- Click on Login to cPanel

Step 2: Open Remote MySQL Section
- Scroll down to the Databases section
- Click on Remote MySQL
This feature is provided inside cPanel.

Step 3: Add Remote Host
You will see a field called Host (% wildcard allowed).
Enter the IP address of the remote server or application.
Example:
192.168.1.10
Then click Add Host.

Step 4: Verify Host Added
After adding, the IP will appear in the list of allowed hosts.
This means the server is now permitted to connect to your MySQL database.

Step 5: Connect to Your Database Remotely
After enabling remote host access, you can connect to your MySQL database using any MySQL client application.
Use the following database credentials:
- Database Host: Your server hostname or IP address
- Database Name: Your MySQL database name
- Username: Your MySQL database username
- Password: Your MySQL database password
- Port: 3306 (default MySQL port)
Popular MySQL client applications include:
- MySQL Workbench
- phpMyAdmin (if available remotely)
- DBeaver
- HeidiSQL
- Navicat
Once the correct credentials are entered, you should be able to access and manage your database remotely.
When Should You Use Remote MySQL?
Use it only when necessary:
- External application integration
- SaaS platforms
- Remote reporting dashboards
- Multi-server architecture
For normal websites, local database access is always preferred.
Steps to Remove host access
When you don’t want a host to access your MySQL databases remotely, you can remove them by performing following steps :
1. Log in to cPanel.
2. On the cPanel home screen in the Databases section, click on Remote MySQL.

3. Under the Manage Access Hosts option, identify the host for which you want to remove the access, and then click on Delete.

4. Click on Remote Access Host. cPanel will remove the host.

Conclusion
Configuring Remote MySQL access in cPanel is simple but powerful. When done correctly, it enables seamless database connectivity between servers and applications. However, proper security practices must always be followed to protect your data.
By following this guide, you can safely configure remote access and improve your hosting flexibility.
