Configuring Navicat for remote MySQL access

 

Navicat is a powerful remote admin tool for Windows and Mac OS X. There's a premium version and a lite version available at Navicat.com.

There's a bit of pre-config work to do in cPanel before you can use it if you wish to access your database via a remote computer.

 

  1. Login to the your cPanel account.
  2. Click on REMOTE MYSQL
  3. Enter the IP address of your computer as an Access host. If you don't know what it is, go to http://aegishosting.co.uk/support/ip.php. If you have a dynamically assigned IP address for your computer from your ISP, this is likely to change each time your internet connection drops.

 

Now to configure Navicat.

 

  1. Create a new connection
  2. Enter the IP address of your server or your domain name without the www.
  3. Port is 3306 (make sure that port is open in your local firewall if you have one)
  4. Enter the username of a specific database, this usually looks like this:  usernam_dbname
  5. Enter the password for that database user
  6. Click on 'Save password'
  7. Click 'Test Connection' to confim it works and if it does, you're good.

 

 

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Accessing your MySQL databases remotely

In order to access your MySQL database from a remote computer you need to first tell the server...

Using SSH Tunneling with Navicat

Navicat allows access to your MySQL database directly via TCP/IP port 3306 or via ssh tunneling....