How to Use PuTTY for Remote SQL over SSH Tunneling with NaviCat?

decibel.places 7:42 pm on December 23, 2009 | Answers: 1    
Tags: localhost, navicat, putty, remote sql, sql (61), ssh (3), ssh tunnel, xampp (3)

Rate Knowledge: (2 votes)

 Loading ...

• decibel.places 7:42 pm on December 23, 2009
  

  Some hosting companies allow SSH but not remote SQL admin with tools like NaviCat. So you need to tunnel in with SSH then connect NaviCat to your localhost.

  Here are the steps:

  1. This page explains how to use PuTTY for a SSH tunnel with screenshots, easy to follow.

  2. Once you are connected, use NaviCat to connect to your localhost on IP 127.0.0.1 on port 3306. I think you may need to have a localhost SQL server set up, I use Xampp use your localhost SQL login – DO NOT use the SSH tab in NaviCat, just the General tab.

  3. You’re in and you will see the domains on your remote server in NaviCat. Open one and you will see the database tables. Voila!

  (this works on Hot Drupal, should work on any host with SSH shell access)