cPanel

How to Use Remote MySQL Feature on cPanel

Introduction

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: http://whatismyipaddress.com/ . Or you can specify a domain name www.twitter.com 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

Conclusion

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.

Add Comment

Click here to post a comment

Join thousands of subscribers worldwide

and get awesome deals & the newest tutorials to your email

Please wait...

Thank you for sign up!

More in cPanel
How to Add a Redirect for Your Website

Close