3Sep/090
MySQL over SSH tunnel
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).