I've created an SSH tunnel to a MySQL server on port 3333 (of the
local machine), however, I'm still unable to connect to the MySQL
server.  Here's the command I'm trying:

mysql -u root -ppassword --port 3333

Here's the error I'm getting:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

The command I'm using to create the tunnel:

autossh -2 -fN -M 0 -R 2200:localhost:22 root@servername.com -i
cert.pem -L 3333:127.0.0.1:3306 -o UserKnownHostsFile=/dev/null -o
StrictHostKeyChecking=no

Any ideas?

yawnmoth wrote:
> I've created an SSH tunnel to a MySQL server on port 3333 (of the
> local machine), however, I'm still unable to connect to the MySQL
> server.  Here's the command I'm trying:
> 
> mysql -u root -ppassword --port 3333
> 
> Here's the error I'm getting:
> 
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
> 
> The command I'm using to create the tunnel:
> 
> autossh -2 -fN -M 0 -R 2200:localhost:22 root@servername.com -i
> cert.pem -L 3333:127.0.0.1:3306 -o UserKnownHostsFile=/dev/null -o
> StrictHostKeyChecking=no
> 
> Any ideas?

By default the mysql client tries to use the socket, you need to tell it to
use the tcp connection instead by adding

-h 127.0.0.1

-- 

  //Aho