How to Use Remote MySQL Feature

How to Use Remote MySQL Feature

Enabling remote MySQL access can be beneficial for several reasons. This feature allows remote hosts (different servers) to access your mySQL database. For example, if you want to allow a third party, such as a shopping cart application, to use the database.

Things needed:

  • Access to your cPanel account
  • The IP address or domain name you want to grant access to

Step 1. Find and Access the Remote MySQL Feature

Find and open Remote MySQL® tool under the Databases section.

remote mysql tool in cpanel

Step 2. Allow Remote Server Access to Your Databases

Enter the hostname or IP address in the Host field. If you want to access the database from the localhost, you can use your public IP address which can be found here. Or, simply enter a fully qualified domain name, like www.3dcart.com, then click Add Host.

add the host to access database

Note: You can use the (%) character as a wildcard. For example, if you wish to grant access for all IPs that begin with 192.168.0, simply enter 192.168.0.%.

Step 3. Delete Remote Server Access to Your Databases

To remove previously granted access, you can do the following:

  1. Find the hostname you wish to remove in the Manage Access Hosts list, and click Delete.remove a hostname from the list
  2. A confirmation window will show up, and simply click Remove Access Host.

a confirmation window to remove the hostname

And that’s it. You can easily allow and remove remote access to your MySQL databases. For security reasons, please don’t give permission to an unauthorized person.

  • cpanel, remote sql, remote mysql, mysql database, mysql
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Access to the Control Panel (cPanel)

cPanel is a web hosting account management toolYou only get one username per cPanel. If you...

Access to the Easy Web Site Builder

To access to the Easy Web Site Builder that contains over 1000 ready-to-use templates are now...

How to Check Bandwidth

Step 1. Access a Short Summary of Bandwidth Usage When you log in, you can immediately see the...

Creating a Subdomain

How to Create a Subdomain Log into cPanel. In the Domains section, click on the Subdomains...

How to Configure Dreamweaver for FTP

How to Configure Dreamweaver for FTP If you are using Dreamweaver as your site designer, you...