!!To forward a port with ssh:

%%prettify 
{{{
ssh -2 -f -C -N user@servername.com -L localport:localhost:remoteport
}}}
/%

In this example then, you can use 3307:localhost:3306 to use your local MySQL admin to manage a remote database.  In MySQL Admin, collect to port 3307 on 127.0.0.1, NOT localhost!

!Connect to MySQL over forwarded port:

%%prettify
{{{
mysql --user=db_role --password=db_user_password --host=127.0.0.1 --port=3307
}}}

%%prettify
{{{
ssh -f -L 1234:server.example.com:6667 server.example.com sleep 10
irc -c '#users' -p 1234 pinky 127.0.0.1
}}}
----
[Linux.Shell | CategoryArchived.Computing.Linux.Shell] - [SQL | CategoryArchived.Computing.DB.SQL] - [Networking | CategoryArchived.Computing.Networking]