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 our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Comments

Post a comment
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
4,023 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.

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

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

Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 1891
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5130

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

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!