[nycbug-talk] mysql ssh & fBSD

[Okan Demirmen]

On Thu 2006.03.02 at 16:31 -0500, Mikel King wrote:
> I have two mysql dbs running on different fBSD boxes on different  
> nodes of the net. I figured out the ssh tunnel part but for some  
> reason when I try to connect like so:
> 
> # establish the background tunnel
> ssh -N -f -L 4406:127.0.0.1:3306 some.other-box.com
> 
> #attempt to connect from the local mysql client to the remote server
> mysql -P 4406 -u joe_user -p
> 
> All I end up with is a connection to the local db and not the remote  
> one. Any ideas why this doesn't work even though the docs I'm  
> following are claim it should.

anything in ~/.my.cnf ? i bet mysql client is using the local socket
instead. try adding "-h localhost".