How to connect to the MySQL Database remotely

Note: If connecting from your home computer, you need a MySQL client like Navicat, phpMyAdmin, or Dreamweaver.

Configuration Settings:

Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

Enable Your Computer as an Access Host

By default, all IPs are blocked and must be added to an access list in order to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.

Allow Remote access in cPanel

(Shared, Reseller. VPS, Linux Dedicated):

  1. Click the Remote MySQL icon, under Databases.
  2. Type in the connecting IP address, and click the Add Host button.
  3. All done, try connecting remotely.

How can I find out my computers IP address?

Simple, just go to http://www.whatismyip.com/

Notes regarding dynamic IPs.

Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.

Before you can connect:

Many of our servers block port 3306 inbound, if you are getting a "Connection Refused" error when trying to connect please submit an email to support@dtechghana.com requesting that we open port 3306 for your IP address to be able to connect to MySQL remotely.

After whitelisting your local IP, you should be able to make the proper remote MySQL connection. Be sure that the username you use matches the username created in the My SQL database section of cPanel. The most common problem in connecting is due to the use of an incorrect username and password.

I enabled remote access, now what?

You will need a third party application to access MySQL remotely. Some are free and some cost money. For a list of applications, you may want to visit our page on:

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Monitor the servers's status

This can be done in cPanel, in the left hand menu. Scroll to the bottom and find the link for...

What are my nameservers

Not sure what the names servers are for your website's domain name? Kindly refer to the welcome...

How do I add another domain to my Account?

All D-Tech shared Linux hosting plans allow you host multiple domains on the same account. To...

How Do I Create and Remove an Addon Domain?

An addon domain is a fully functional domain that can be created from within your control panel....

How do I manage my Shared hosting account?

We offer cPanel to manage your Shared Web Hosting account. You can learn more about cPanel here