first part is the local connection second part is the remote target and the -p is the port you are running on on that remote target...
then that would allow you to run the mysql manager and point it at localhost but will actually be running over the tunnel. This is for the mac/posix world (not windows) On Wed, Oct 13, 2010 at 1:05 PM, Steve Ross <nowhid...@gmail.com> wrote: > ssh tunnel for mysql: > > ssh -N -L3306:localhost:3306 usern...@192.168.0.01 -p 7861 > > > On Wed, Oct 13, 2010 at 12:56 PM, Mike Staver <sta...@fimble.com> 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 >> ------------------------------------------------------------- >> >> >> >> > > > -- > Steve Ross > web application & interface developer > http://blog.stevensross.com > [mobile] (912) 344-8113 > [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] > -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
