Assuming that you have the ssh daemon running already on your
MySql/Linux box...
Download and install PuTTY. http://www.putty.org/
You can then create a tunnel in Putty and tell it which ports to
forward. (in this case, 3306)
It is fairly easy, I can help some more if you have questions about it.
Personally I use a linux client to connect to cygwin SSH on a windows
server, but I have instructed the non-techie owner of the website how to
use Putty to connect from his own windows PC.
Once Putty is installed and is running you can connect with the normal
MySql Query Browser/Admin tools. You just replace the server IP with
127.0.0.1 in order to utilize the forwarding provided by Putty.
--Frank
On 10/13/2010 12:56 PM, Mike Staver wrote:
I'm trying to set up a remote dev instance for one of my applications,
and what I would like to do is have it connect to my mysql instance on
a linux box I run. I don't plan on opening up port 3306 to the
outside world for obvious reasons, and I shouldn't need to if I'm
correct in my thinking here. Currently, I use Navicat to connect to
the DB over an SSH tunnel and it works great. I'm not entirely sure
how Navicat does this behind the scenes, and I'd love to know how to
duplicate this on both windows and Mac OS Has anyone done this
before? On the Mac or Linux side, I would imagine you'd just set up
some kind of port forwarding that would do this for you. I'm very
unsure of how that would work on windows.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
