How to connect to the MySQL server remotely

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

Configuration Settings:

Host = (use the server IP address)
Database name = (cpanelusername_databasename)
Database username = (cpanelusername_databaseuser)
Database password = (******)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

Before you can connect:

Our firewall blocks port 3306, so please submit an email to support@hostgator.com requesting that we open port 3306 for

-or-

When using X, login to cPanel and click the MySQL Databases icon, under Databases.

Scroll all the way to the bottom and type in the connecting IP address where it says "Host (% wildcard is allowed):", and click the Add Host button.

All done, try connecting remotely.