Navicat: Connecting to WHM servers (viewing all server databases)

Navicat and other such programs allow you to view and edit your MySQL databases from your desktop.  They are often easier to use then phpmyhadmin.  They offer a GUI interface between you and the server.  This tutorial teaches you how to connect Navicat to a dedicated server you have full root access to, in order to view ALL OF the databases on a server at once time.  This tutorial also applied for other such mysql manager programs.  We just selected Navicat for its ease of use, but all settings stated should be identical in most cases.  The LITE version of Navicat is available free for testing here.

What you need first....Ports and passwords:

To use this method SSH must be allows for the server on port 22 and port 3306 must be open both in and out to allow access to MySQL.  Please check with your firewall settings or any of our staff to see if these ports are open.  You also need the ROOT MYSQL password for the server.  This can be reset my going into your WHM and looking for the option
MYSQL ROOT PASSWORD
reset that first and write it down. 
You will also need the root username and password to the server itself which should be the same login you just used to get into the WHM interface.

Setting up NAVICAT:

Goto the connection properties screen and start in the general area:

Connection name: just enter the name to call the connection, can be anything.
Host name: localhost
Port: 3306
username: should usually be root
password: should be the MYSQL ROOT PASSWORD you just created above.

OK not click on the SSH tab, you will be creating what is called an SSH tunnel to access your databases:

Click Use SSH tunnel ON
Hostname: enter the master IP address of your server
Port: should be 22
username: username of SSH and the WHM, which is usually root
password: your master SSH and WHM password

THAT'S IT, you are done, try to test your connection.  If it does not work your ports are not open or your passwords are not correct.

Connecting to just ONE database or account instead of all of them:


The above shows you how to connect to all databases on a server.  But you may want to just access one account or you may want to give a user access to his database.  This can be done as well.  To do this the user must know the IP address of his personal computer.  He can find it by going to whatismyip.net

1) Login to the individual user's CPANEL account
2) Click on REMOTE MYSQL
3) Enter the IP address of his computer as an ACCESS host


Configure Navicat. 

4) Enter any connection name
5) Enter the IP address of the server or the users account
6) Port is 3306 (make sure that port is open in the firewall)
7) Enter the username of the user's specific database, this usual looks like this:  usernam_dbname
8) Enter the password of the specific database

That is it.  You do not have to use the SSH settings in this case.  This will gain the user access to all databases that are linked to that username.