Posts Tagged ‘SSH’

Rarely but happens when you have to log in to a remote server using password instead of public-key authentication. It’s very easy to do:

ssh -o PubkeyAuthentication=no user@machine

It happened to me on Mac when I had the key in keychain and tried to log in to a different server with the same name. Keychain tried to supply my key.

Advertisements

MySQL over SSH tunnel

Posted: October 19, 2010 in MySQL, Shell scripting
Tags: , , , ,

Sometimes we face a problem when we have SSH access to the server, but not to MySQL.
Here is a simple workaround – SSH tunnel:

ssh -f -N -L LOCAL_PORT:127.0.0.1:3306 USER@HOST

This command allows you to map remote port to the local one via SSH tunnel.

  • LOCAL_PORT – local port to map to
  • USER – SSH username
  • HOST – remote host

Surely, you can map other ports as well.

When you mapped the port, you can connect to MySQL using your favorite client (you need to specify LOCAL_PORT as MySQL server port in connection settings).