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.

Add to Favourites    Print this Article

Using SSH Tunneling with Navicat (Views: 68)

Accessing your MySQL databases remotely (Views: 351)