How to connect to remote MySQL server by SSH tunnel

Run:
ssh -L  3306:127.0.0.1:3306 database@goyun.info
-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


Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows