Connecting to a cPanel MySQL database using Navicat

Before you start

The first thing you need to do is ensure that you enable external MySQL database access, then make sure you have setup a database and database user within cPanel.

The last thing you need is the server hostname/address, you can obtain the address by following these steps:

1. Log in to VIPControl.
2. Click on My Services at the top of this page.
3. Click on cPanel Hosting.
4. Click Manage.
5. Under cPanel Details you will see cPanel Hostname, that is the server’s address/hostname (this can be used for MySQL connections too). You can also use the IP address from the Server Details tab here.

How to connect

1. Open Navicat.
2. Click on Connection and then select MySQL.
3. A dialog box will appear, where you will input the following information
   1. Connection Name: this can be anything you’d like, used to remember your session.
   2. Host: the address of the server you want to connect to (refer to Before you start)
   3. Port: 3306
   4. Username:  Your MySQL database username
   5. Password: Your MySQL database password
4. Click Test Connection
5. As long as the test comes back okay, click OK