How to Use Remote MySQL Feature on cPanel

In this guide, you will learn how to use Remote MySQL feature that allows remote hosts (different servers) to access your MySQL databases on your account. This is useful, for example, if you wish to allow shopping cart or guestbook applications on other servers to access your databases.

What you’ll need

Before you begin this guide you’ll need the following:

  • Access to your cPanel account.
  • IP address or a fully qualified domain name that you want to have access to your MySQL databases.

Step 1 — Accessing your cPanel and locating the Remote MySQL feature

Access your cPanel using your login credentials. Afterwards, you will need to find the Remote MySQL feature, which is located under Databases section.

Remote MySQL feature.

Step 2 — Allowing a remote server to access your databases

  • Enter the host’s name (another website or server) or IP address in the Host text box. If you are trying to access your database from your local computer that is running an application you should use your public IP address that can be found here: . Or you can specify a domain name for example.
  • Add Host
  • Click Add Host button.
  • confirm Host

IMPORTANT! You may enter a fully qualified domain name (FQDN) or an IP address.
You may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 192.68.0, enter 192.68.0.%.

Step 3 — Removing the remote server access to your databases

To deny access to your databases from a remote host that You have added, perform the following steps:

Remove Host

  • Click the Delete icon next to the host’s name or IP address.
  • confirm removal of Host
  • Click Remove Access Host.
  • finished removal of Host


After following this tutorial you now know how to allow a remote machine(host) or a website to gain access to your MySQL databases and remove the access if needed.

About the author

Elvinas S.

Elvinas is a senior server administrator at Hostinger. He monitors the infrastructure’s well-being and keeps the uptime at a maximum. Besides server management, web development has always been one of his biggest passions.

Add Comment

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get Exclusive Content

Join thousands of webmasters who get our free newsletter with tips on how to drive more traffic and revenue to their websites!

Please wait...

Thank you for sign up!

More in cPanel
How to Add a Redirect for Your Website