Remote MySQL Database Connection
In this tutorial, we'll show you how to setup a remote mysql connection within your cPanel so you can connect and work with your databases remotely.
This feature may be useful if you want to allow shopping carts or CMS systems that are hosted on other servers to use MySQL databases in your cPanel account.
Allow a remote server to access your databases
To specify remote hosts that can access MySQL databases on your account, perform the following steps:
Log into cPanel.
Click the Remote MySQL link in the Databases section:
You may enter a fully qualified domain name (FQDN) or an IP address in the Host text box:
You may use the percentage sign character
(%) as a wildcard. For example, to allow access from all IP addresses that begin with
Click Add Host.
Confirmation message will appear:
All added remote connections will appear in the Manage Access Hosts table below the insert form:
Deny a remote server access to your databases
To deny database access to a remote host, click Delete next to the host’s name or IP address.
Confirm deletion on the next screen:
Click Remove Access Host.
A message will confirm the deletion:
Which programs support a remote mysql connection
Advanced HTML editors like DreamWeaver can connect databases remotely. There are Free Open Source programs like MySQL Workbench or Heidi SQL you can use.
Troubleshooting Remote connection issues
If your remote connection program surprisingly returns a "1045 - Access denied user" error, there are a few things you might want to check out.
cPanel password has been changed
Often, users connect remotely with MySQL through their cPanel username and password instead of creating a separate MySQL user.
If the cPanel password has been changed and has not been updated in the remote connection software, it will trigger the above error.
IP address has been changed
If you have dynamic IP address at home make sure it matches the record in the Manage Access Hosts table otherwise your connection to MySQL server will fail.
If your situation is neither one of these please contact the technical support for assistance.