Comments on Securing the connection between MySQL and MySQL Administrator using an SSH tunnel

Securing the connection between MySQL and MySQL Administrator using an SSH tunnelThis is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.

8 Comment(s)

Add comment

Comments

By:

Make sure you use 127.0.0.1 or another alias (such as something hosts file) to make the mysql connection. If you use "localhost" mysql, you will not be able to authenticate properly since mysql will think you are trying to use the local socket.

This article is not incorrect, but I didn't want any to go crazy with authentication problems trying to use localhost.

By: Matthew M

One problem --

This works if you're sitting at a PC and want secure access to your MySQL server. But what if you need to run a process once a day on your home server (or PC) and need a STABLE connection to your remote MySQL server?

In other words, how do you connect to the server again when the connection gets dropped for whatever reason? How do you "re-open the tunnel" when it caves in, so to speak?

Thanks,

Matthew

By: Anonymous

You use screen command line application in linux to use persistent connections.

Greetings from Chile

By:

I tried this but no dice. As requested, I opened a case in the forums.

This is a cool idea, tho'. For those who get it to work it's probably pretty cool!

By:

I managed to connect to the server using MySQL Administrator. If you use an account other than root it needs to be able to login locally.

I got the following error message on connection: Either the server service or the configuration file could not be found. Startup variables and service section are therefor disabled. I suspect the author of this procedure has MySQL Administrator running locally and used this procedure to get a copy running on another machine.

Startup variables and service section are only available locally. This procedure when complete would be a great work around for those systems that don't run MySQL administrator locally. I suspect some local config files need to be installed on the server to support the software. If I get it to work I will leave the bread crumbs.

By: Anders

It´s working perfect. Thank you so much!

By: iTiki

Just sending some mad gratitude for the precise instructions. Worked immediately with no alterations needed.

By: Anonymous

Thanks for creating this page