Download NavicatYou 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.

http://www.navicat.com/en/download/download.html

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

Click Remote MySQLBefore you can get Navicat to connect, you will need to add your IP to the Remote MySQL connection.

You can do this by Logging into your cPanel click the Remote MySQL icon in the Databases section.

Add IP to Remote MySQLAdd 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

  1. Open Navicat.
  2. Click the Connect button NavicatClick the Connection button at the top right of Navicat.
  3. Click Test Connection NavicatEnter your Database Connection credentials.

    Database Credentials

    Connection name: Name this whatever you want
    Host Name/IP Address: Use your Domain name or Your cPanel IP address
    Port: 3306
    User Name: Your cPanel user or database user that was created
    Password: he cPanel or created user password

    Click Test Connection.

  4. Successfull connection NavicatYou 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.


  5. Click Done NavicatClick Ok again to accept the Connection Settings.
  6. View databases in NavicatYour Database connection will show in the left pane listing the names of the database. Click one of the databases to look at the tables.

    View tables in database of NavicatNow you can see all the options in Navicat. The tables will list in the main window.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-04-02 9:19 pm

Good.  But ... what do we do with the error message:  too many connections.  Need to flush-host.  

Staff
9,162 Points
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.
n/a Points
2014-06-14 3:18 am

how i can insert new row in table in navicate

Staff
9,162 Points
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.
n/a Points
2014-09-27 3:30 pm

Hi,

 

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,

 

Nick

Staff
19,557 Points
2014-09-28 10:28 am
Hello Nick,

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.

Kindest Regards,
Scott M

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

6 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!