[TriLUG] [TriPUG] [MySQL] seeking ssh tunnel advice

[Tom Roche]

Tom Roche Jan 11, 2008 11:22 PM
 >> if in fact I [turn off port forwarding and] utter

 >> $ ssh -fNL 3306:192.168.0.12:3306 os2 at netgear.dyndns.org &
 >> $ mysqladmin -h netgear.dyndns.org -u mysql2 version

 >> *in the same shell*, I get

 >>  > error: [...]

David Rasch Jan 12, 2008 9:15 AM  
 > When you do SSH forwarding, you'll need to change your connect
 > string to connect to your localhost to use the tunnel.

 > Try this:

 > $ ssh -fNL 3306:192.168.0.12:3306 os2 at netgear.dyndns.org &
 > $ mysqladmin -h 127.0.0.1 -u mysql2 version
                  ^^^^^^^^^

DOH! Of course! the entry to the tunnel is my laptop. And empirically,
that works, as does

$ mysqladmin -h localhost -u mysql2 version

Thanks! Tom Roche <Tom_Roche at pobox.com>