connection over ssh tunnel???

[Fabiola]

Hello guys,
Running 4.1.11 on FC4, i wana connect to it remotely via an ssh tunnel. Logging on locally, all works fine i.e. mysql -h localhost -p gets me in.

I setup my ssh tunnel from on another box:
remotebox# ssh -N -L3306:localhost:3306 root@mysqlserver.somewhere.com

I get the following error:
remotebox@root:~$# mysql -h localhost -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Things i've done:
moved socket=/var/lib/mysql/mysql.sock to socket=/tmp/sock for both server and client in my.cnf, on both systems.

This is how mysqld is started
/bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysq -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try to make a telnet localhost 3306 to see what's going on. Then check that you don't have another copy of MySQL local, using the same port, in that case you can make an ssh tunnel to the remote server, opening a new local port eg. 3030:

SSH TUNNEL:

nohup ssh -l root -a -g -N -x -T -L 3030:REMOTESERVERIP:3306 REMOTESERVERIP &

Make sure you have a rule in the remote server iptables to allow REMOTESERVERIP to connect to that MySQL locally, eg.

IPTABLES RULE:

-A INPUT -s REMOTESERVERIP -p tcp -m tcp --dport 3306 -j ACCEPT

The applications running MySQL must use the port 3030 instead of 3306. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --