How to Access MySQL Server remotely Over SSH?

view full story

http://lpilinux.com – we’ll just use port-forwarding through an SSH tunnel, so your MySQL client thinks it’s connecting to your localhost machine, but it’s really connecting to the other server through the tunnel. If you are using the command line ssh, the command would look like this. (You can do the same thing graphically in Putty or SecureCRT options if you need to) ssh -L 3306:localhost:3306 [email protected] The syntax is ssh -L hostname (HowTos)