Additions:
see also
SshLocalPortForward
SshRemotePortForward
example howto make a remote mysql server appear on localhost port 3306
by binding local 3306 port to remote 'localhost' mysql 3306 port
$ ssh -L3306:localhost:3306 myremoteusername@remote.server
SshLocalPortForward
SshRemotePortForward
example howto make a remote mysql server appear on localhost port 3306
by binding local 3306 port to remote 'localhost' mysql 3306 port
$ ssh -L3306:localhost:3306 myremoteusername@remote.server
Deletions:
by binding remote 'localhost' 3306 port to the local 3306 port
$ ssh myremoteusername@remote.server -L3306:localhost:3306
Additions:
==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
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
Deletions:
NOTE
DO NOT use 'localhost' in your mysql command line / mysql qui but add an alias to /etc/hosts since use of 'localhost' forces use of a socket which does not exist locally !
$ mysql -h mysshsql -p
Additions:
NOTE
DO NOT use 'localhost' in your mysql command line / mysql qui but add an alias to /etc/hosts since use of 'localhost' forces use of a socket which does not exist locally !
127.0.0.1 mysshsql
$ mysql -h mysshsql -p
DO NOT use 'localhost' in your mysql command line / mysql qui but add an alias to /etc/hosts since use of 'localhost' forces use of a socket which does not exist locally !
127.0.0.1 mysshsql
$ mysql -h mysshsql -p
Additions:
$ ssh myname@remote.server -L3306:localhost:3306
Deletions:
Additions:
>>http://magazine.redhat.com/2007/11/06/ssh-port-forwarding/
>>===SshPortForward===
>>===SshPortForward===
