How do i setup Navicat to work with my databases?

 

Navicat is a popular desktop database management tool for several different database servers: MySQL, SQLite, Oracle, and Postgresql. In this example, we are going to setup access using the Navicat MySQL edition since we do not support the other RDBMS servers listed here on our shared servers. This example is based completely on MySQL only.

 

1. The first step is to login to your cpanel control panel:  

 

mydomain.com/cpanel

 

2. If you do not have your cpanel login information, you can obtain this at anytime yourself through the online client billing portal. Please follow the directions as provided in this KB article:

 

How to view or change the cPanel Password

 

3. Under the "Databases" column you will see a section "Remote MySQL", click on it.

 

4. In there you will see a text input box "Add Access Host" this is where you will add your public ip address in so your IP is added to mysql's Allow Host field. If you do not know how to locate your IP address, visit this link and paste it into the text box:

 

myip.my-tss.com

 

5. Next make sure you have a mysql username & password setup under the "MySQL databases" section. And the username is assigned privileges to the database, otherwise you will get errors when attempting to connect.

 

6. The connection details you will provide to Navicat are as follows:

 

Host: yourDomainName.com

User: cpanelusername_MySQLusername

Password: MySQLpassword for cpanelusername_MySQLusername

Port: 3306

 

That is it! you will now be able to connect via Navicat to manage your databases from your desktop session.

 

Reviewed: 11/05/2016

  • Email, SSL
  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

What if I need more hard drive space or bandwidth? - delete

Submitted by user: I need more HD space.. There are a few other companies out there that are...

What language can I program in? Where can I download scripts?

For the most part PHP is the most common scripting on the web. Many other scripts and programs in...

Help - my site's been infected by a Virus

The viruses that attach themselves to web pages are unfortunately common, and though they are...

Fix for FrontPage hit counter on subdomain

Problem: You're using MS Front Page with web bots. The hitcounter works fine on your main domain,...

Can you tranfser files from my old host to you?

If your current web hosting provider has cPanel all you would need to do is create a BACKUP of...