InMotion Hosting Support Center

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.

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.

Was this article helpful?

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

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

n/a Points
2018-12-16 5:41 am

1045 - Access Denied for user (using Password: YES) 

3,862 Points
2018-12-17 1:06 pm
I recommend ensuring your user's privileges are properly set up for access to that database. If they are then you may need to reset the password.
n/a Points
2018-12-06 6:47 am

Thanks brother its working very well

3,862 Points
2018-12-17 1:05 pm
You're welcome! We are glad to see you are satisfied, thanks for the feedback.
n/a Points
2016-11-18 2:15 pm

I only see a database named information_schema, but I have three other databases. How do I see the others?

2,858 Points
2016-11-18 2:22 pm
Edwin, I would ensure that <a href="">the user you are connecting with has access / privileges</a> to the databases you're attempting to see.
n/a Points
2016-09-14 2:21 pm

Hello - I have navicat essentials for mac. 

When i open Navicat and connect through the localhost connection i have - it connects but does not show the list of databases on localhost. If i connect on terminal through the same user - i can see the list of databases in there. Same user - and Navicat is connecting with the credentials. Just that i cannot see the list of the databases in it on localhost.

Any suggestions please

42,946 Points
2016-09-14 4:42 pm

When you connect with Navicat, it is connecting through a user and port that enables it to look at a single database at a time. It is not a replacement for the application (phpMyadmin) that is installed on the server for that purpose. You can build a library of connected databases using remoteMySQL connections, but it will not list all of the databases for you to open like phpMyAdmin does. I hope this helps to explain it. If you have any further questions or comments, please let us know.

Arnel C.
n/a Points
2016-09-11 11:35 am

Thanks broo its working very well

n/a Points
2016-04-21 4:12 pm

when I try to connect, I get the the error message 1130-Host W231 is not allowed to connect to this MySQL server

31,595 Points
2016-04-21 4:30 pm
Hello Sheila,

Thank you for contacting us. Since you are getting a "not allowed" message, ensure you have added your IP address to remoteSQLas described above, which allows access to the server by adding the IP to the firewall.

Thank you,
n/a Points
2016-02-27 7:00 am

I am trying to make new connection with navicat, but I am not able to which username and passwod I should give to it, I am using wampserver phpmyadmin without any username or password. please help

43,761 Points
2016-02-29 3:23 pm
The credentials (username and password) for navicat would be the ones for the database you are connecting to. If you are not using any, try without it, but it should at least have a username.
n/a Points
2015-12-03 8:56 am

Hi please teach me how to make a new database in navicat prem. thanks.

31,595 Points
2015-12-03 5:21 pm
Hello black,

Thank you for contacting us. Here i a link to a helpful video I found online titled "How to Create Database and Table with Navicat Premium." It should help you get through the process.

Thank you,
n/a Points
2015-12-04 7:56 am

Thank you so much so helpful :)

n/a Points
2015-09-17 1:44 am


when I want to connect this error is apear: 2003 Can't connect to MySQL server on '....... ' (10038)

31,595 Points
2015-09-17 11:55 am
Hello ali,

Thank you for contacting us. I recommend reviewing your Database Credentials for typos or misspellings.

Also if you are connecting to a remote server, ensure you are using the domain name, instead of localhost, and you have Added an IP address to allow a remote MySQL connection.

Thank you,
n/a Points
2015-06-10 2:44 am

I recommend people also investigate some open-source options such as HeidiSQL or SQuirreL.  Myself, I have just downloaded HeidiSQL as it is licensed under the GPL 2.0.

42,946 Points
2015-06-11 3:16 am
Thanks for the comment Adam. I agree with you, HeidiSQL works very well. You can also download the phpMyAdmin client from here.

Arnel C.
n/a Points
2015-04-10 9:00 am

hello jeffma i have a problem with navicat ...

1. when i open procedure in database it dones not show me any procedure 

when i change ip it shows me all procedure i have made what should i do to see all procedure i have made for my database please help


43,761 Points
2015-04-13 8:33 am
Hello afzaal,

If you are one of our customers, you cannot run stored procedures on our shared servers and can only do so on VPS and Dedicated accounts with the MySQL root account.

Kindest Regards,
Scott M
n/a Points
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,



43,761 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
n/a Points
2014-06-14 3:18 am

how i can insert new row in table in navicate

11,186 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-04-02 9:19 pm

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

11,186 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

Email Address:
Phone Number:

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

28 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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:
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!