[SLUG] ssh - localhost, mysql

["Sonia Hamilton" <sonia@xxxxxxxxxxxx>]

On Fri, 28 Mar 2008 12:46:12 +0900, "jam" <jam@xxxxxxxxx> said:
> Using a fresh install of Gutsy, and having apt-get install openssh-server
> he tunnels to me
> 
> ssh -R 1200:localhost:22 ian@xxxxxxxxx
> 
> I then go back the tunnel to his machine
> 
> ssh -p 1200 ian@localhost

Slightly OT question related to this. How would I prevent ssh
complaining about changed ssh keys for localhost? (Because I regularly
tunnel via localhost, but to different ips).

And a very OT question related to this. Whenever one connects to mysql
via localhost, mysql will use the local socket rather than connecting
via tcp. This obviously fubar's when one has got localhost connected to
an ssh tunnel. Anyway around this? There's a mysql option
'protocol=tcp', but it doesn't appear to work. There's an angst filled
bug post about it here: http://bugs.mysql.com/bug.php?id=31577

Thanks,

--
Sonia Hamilton.