How to Connect to the MySQL Database Remotely

[topvip]

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

See our article on Managing Your Database with Applications for some suggested programs and more details.

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.

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@hostgator.com requesting that we open port 3306 for your IP address to be able to connect to MySQL remotely.

Also, before you can connect to MySQL from another computer, you must enable your computer as an Access Host. It may sound confusing, but cPanel makes this very simple.