SSH Tunnel to MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • djn
    Senior Member
    • Mar 2004
    • 140

    SSH Tunnel to MySQL

    Hello all.
    This would belong to the HowTo at http://forums.dathorn.com/showthread.php?t=216 ("How to setup a SSH tunnel to access MySQL from outside"), but it seems I'm not allowed to add to that thread so I'm posting in a new one.

    In short, the SSH Tunnel FAQ explains how to use plink.exe to set up an encrypted tunnel and remotely manage your databases on cpanelXX with the tool of your choice. Plink is a component of the open source Putty SSH client and it's a command line thing, which means learning obscure syntax and such. The alternative, a plink frontend named SSH TunnelClient, is free for non-commercial use only, otherwise you're supposed to pay for it.

    Well. I've just found another GUI frontend to plink and this one is a plain freeware with no use limitation. Check it at
    http://nemesis2.qx.net/software-myentunnel.php

    Once installed you just launch it and select the Settings tab to tell it which server you want to tunnel to (cpanelXX.gzo.com, your username and password, port 22, everything else is optional, don't forget to click Save). To set up a SSH tunnel select the Tunnels tab and write 3306:127.0.0.1:3306 in the left panel marked as Local:. Click Save, then Connect and you're done. Go to the Status tab to see what's going on. If you want to redirect another port instead of 3306 (say 3307) just change the first port number (as in 3307:127.0.0.1:3306).

    Just tested with HeidiSQL and Navicat2004, works fine.

    BTW, the link to SSH TunnelClient in the FAQ is outdated. Now the thing is at http://www.delight.ch/de/download/sshtunnelclient
Working...