[nycbug-talk] mysql ssh & fBSD
Thu Mar 2 20:08:32 EST 2006
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".
More information about the talk