SshPortForward
howto make a remote mysql server appear on localhost port 3306
create mysql tunnel
by binding remote 'localhost' 3306 port to the local 3306 port$ ssh myremoteusername@remote.server -L3306:localhost:3306
run mysql command or gui
then you can use mysql locally to connect to the remote mysql server over ssh$ mysql -h 127.0.0.1 -u myuser -p
NOTE : DO NOT use the hostname 'localhost' in your mysql command line or you will get
Could not connect to host 'localhost'. MySQL Error Nr. 2002 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
since mysql tools treat the hostname 'localhost' as a 'magic' word to force mysql to connect via a local socket instead of a tcp port but the local socket will not exist if your mysql server is not local which it is not if it is remote !
so you must either use 127.0.0.1 or add an alias to /etc/hosts
$ cat /etc/hosts 127.0.0.1 mysshsql
REFERRERS
MySqlFaultFinding
ssh
There are no comments on this page. [Add comment]