Sep 19, 2018

How to connect to remote MySQL server by SSH tunnel

Run:
ssh -L  3306:127.0.0.1:3306 [email protected].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: