Home > Help Center > Shared Hosting > Databases > Remote MySQL Database Connection

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:

remote-mysql

You may enter a fully qualified domain name (FQDN) or an IP address in the Host text box:

hosting.server.net

192.168.1.15

You may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 192.168.0, enter 192.168.0.% :

remote-mysql

Click Add Host.

Confirmation message will appear:

remote-mysql

All added remote connections will appear in the Manage Access Hosts table below the insert form:

remote-mysql

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:

remote-mysql

Click Remove Access Host.

A message will confirm the deletion:

remote-mysql

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.

Still not finding what you're looking for?

Contact our support team with any additional questions or concerns.

Contact support