Connect to MySQL with Navicat
You can connect to your server MySQL databases using Navicat. Navicat is a "Remote MySQL database tool" that allows you access to your database from your local home computer. To connect with navicat you will need to download the software. We will download the following version:
Navicat for MySQL 10.1.8
Download and Install Navicat
You can download navicat at the following url. This version is a Trial version. Navicat is not free they do require a payment to get the Trial removed from your installation.
Once you get the Executable for the program saved to your computer. Click the Installer icon to install Navicat.
Add your IP to Remote MySQL
You can do this by Logging into your cPanel click the Remote MySQL icon in the Databases section.
Add your IP to the Add Access Host and Click Ad host.
For more detailed information on how to do this please see our article on Setting up a Remote MySQL connection in cPanel.
Steps to connect to your database with Navicat
- Open Navicat.
- Click the Connection button at the top right of Navicat.
- Enter your Database Connection credentials.
Connection name: Name this whatever you want
Host Name/IP Address: Use your Domain name or Your cPanel IP address
User Name: Your cPanel user or database user that was created
Password: he cPanel or created user password
Click Test Connection.
- You should get a Connection Successfulpop up.
If not you will need to check the IP in Remote MySQL or check your username and password you are using. You also may need to use the IP and not your domain.
- Click Ok again to accept the Connection Settings.
- Your Database connection will show in the left pane listing the names of the database. Click one of the databases to look at the tables.
2014-04-02 9:19 pm
Good. But ... what do we do with the error message: too many connections. Need to flush-host.
2014-04-03 7:49 am
This message is caused by repeated failed connections to the server. You will need to submit a ticket to technical support for further assistance with this.
2014-06-16 8:40 am
To add a new row in Navicat, click the "+" button in the navigation bar once within the desired table. You can also press Ctrl+N to add a new row as well.
2014-09-27 3:30 pm
Do you have walkthrough how to connect to a remote mysql without cpanel, on ubuntu just using command line to setup whatever is done using cpanel.
Thank you for your time,
2014-09-28 10:28 am
You can connect to the MySQL directly with VPS and Dedicated servers, and even some shared servers using SSH. Remote connection is done through programs such as NaviCat or HeidiSQL. None of these methods use the cPanel itself.