Knowledge Base
MilesWeb / cPanel

Learn to configure Remote MySQL access in cPanel

Approx. read time : 2 min

This article explains how to use cPanel to allow external hosts to access your MySQL databases. You can use remote client applications to connect to your databases directly simply when remote host access is enabled.

# Steps to add host access

1. Log in to cPanel.

2. On the cPanel home screen in the Databases section, click on Remote MySQL.

Remote SQL

3. Under the Add Access Host, in the Host text box, type the domain name or IP address of the host that you want to add.

Note: You can find your IP address by entering a query ‘What is my IP ‘ in search engine.

4. In the text box for Comment, you may add a comment to describe the remote host. This is optional.

5. Click on Add Host.

# Access your database remotely

After enabling host access, you can connect to your MySQL databases remotely by using MySQL client application.

# 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.

Remote SQL

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.

Also Read :

1)How to search MySQL tables in phpMyAdmin?

2) How Can I Check a MySQL Database for Errors in cPanel?

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent 4.8 out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna