How to connect to remote MySQL server by SSH tunnel

Run:
ssh -L  3306:127.0.0.1:3306 database@server.i88.ca
-L [bind_address:]port:host:hostport
             Specifies that the given port on the local (client) host is to be forwarded to the given host and port on the remote side.

Then you can access MySQL server remotely:
mysql  -h 127.0.0.1

See also:

Popular posts from this blog

How to get Active Transactions and Locks from MySQL

Example of a PAC file

How to delete / clear queue of PowerMTA