HeidiSQL SSH Tunnel

gistfile1.txt

NOTE : Following procedure are for windows user.

* Tools needed
- HeidiSQL
- Putty

Steps:

1) Create a new session in session manager and give appropriate name to it
2) In settings tab make changes following:

    * Network type: MySQL (SSH tunnel)
    * Hostname/IP: 127.0.0.1
    * User: <REMOTE_DB_NAME>
    * Password: <REMOTE_DB_PASSWORD>
    * Port: 3306

3) In SSH Tunnel tab make following changes:

    * plink.exe location: <SELECT PUTTY.EXE LOCATION>
    * SSH Host + Port: <IP_ADDRESS_SSH_SERVER> + <22>
    * Username: <SSH Username>
    * Password: <SSH Password>
    * plink.exe timeout: 8
    * Local Port: 2000