SSH Tunneling

posted in: HOWTO | 0

Long ago, in the before time, when I was using Windows I would occasionally tunnel an SSH connection through PuTTY to do VNC / remoting into my work computer. At an AWS workshop I recently learned how to do this with the command line SSH client in Linux and it’s surprisingly simple.

The issue tonight: I needed to do some remote MySQL administration and it was easier to use MySQL Workbench, but the permissions were set on the remote side to limit all connections to localhost. What to do?

In this case, I already had passwordless logins enabled for this site (ie. ssh-copy-id )

ssh -N -L 9000:localhost:3306

Then in MySQL Workbench, I connected to localhost at port 9000 and provided the credentials as if I were logged in remotely!