MySql server: ssh port forward and localhost
I needed to work with a MySql server which was behind a firewall, and only the port for SSH was open. Of course, in this case, I need to use the portforward feature:
ssh example.com -l myusername -L:3306:localhost:3306
However, if I type 'localhost' in MySql Query Browser, it tries to connect via socket - of course which is not avaliable. I tried my local IP and the outer one (I'm behind NAT), but nothing worked... then came the idea: use localhost's IP address! So in the connection window, I typed: 127.0.0.1, and voila, the window opened listing all tables...:)