From Yahoo answers
\nSo you\u2019ve got MySQL on your web server, but it\u2019s only opened to local ports by default for security reasons. If you want to access your database from a client tool like the MySQL Query Browser, normally you\u2019d have to open up access from your local IP address\u2026 but that\u2019s not nearly as secure.<\/p>\n
So instead, we\u2019ll just use port-forwarding through an SSH tunnel, so your MySQL client thinks it\u2019s connecting to your localhost machine, but it\u2019s really connecting to the other server through the tunnel.<\/p>\n
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) If you already have mysql running on your local machine then you can use a different local port for the port-forwarding, and just set your client tools to access MySQL on a different port.<\/p>\n Once you\u2019ve got the ssh tunnel going, you can open up MySQL Query Browser and enter in the details for your remote server, using localhost as the server host, and adjust the port to whatever you used.<\/p>\n Once you get used to this method, you\u2019ll wonder why you ever used phpmyadmin or the command line version.<\/servername><\/username><\/remoteport><\/localport><\/p>\n","protected":false},"excerpt":{"rendered":" From Yahoo answers So you\u2019ve got MySQL on your web server, but it\u2019s only opened to local ports by default for security reasons. If you want to access your database from a client tool like the MySQL Query Browser, normally you\u2019d have to open up access from your local IP address\u2026 but that\u2019s not nearly… <\/p>\n
\n
\nssh -L 3306:localhost:3306 geek@webserver.com
\n<\/code>
\nThe syntax is ssh -L