I've set up an ssh tunnel between my local machine and a remote host ("Fred") as follows: ssh daveg@fred -L 3306:localhost:3306 in an effort to access a remote mysql database running on fred. I've verified that the tunnel is working by telnetting into fred 3306 and seeing the mysql version info from the remote solaris system. If I now enter: mysql --host=localhost -udavid -ppassword (david and password are the mysql username and password), i get the following: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
So, for some reason, mysql is "convinced" i'm running a local mysqld and is trying to hook up to it. Of course there's no local daemon running, so it chokes when it can't find the socket. Is there any reason it is not simply reaching out to port 3306 locally and thus finding the tunnel? thanks, --David Goodstein --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php