Open an ssh Tunnel to Administer MySQL (or anything else)
November 3rd, 2008
Pretty simple stuff, say you are using mysql administrator and you want to point it at a server that you have ssh access to but the firewall prevents you from making a direct connection over the internet (which it should).
Here is what you do (if mysql is running on its default port):
ssh -N -L3306:localhost:3306 username@server.com
You can also pass in a port variable if you are running ssh on a non-starndard port (which you should also do) all you do is add ” -p 1234” (1234 would be the port number where ssh is wanting you to connect)
Now just point mysql administrator at 127.0.0.1 and supply your credentials. Bang. You’re in.
November 20th, 2008 at 03:56 PM
Hi Steven,
How do I get in touch with you? I have multiple Flex/Flash positions open!!
Julie Hansen