Editing Software setup for db-class (section)

==== Test MySQL connectivity tunneling through SSH ====

On my Window clients I use a handy utility called [http://www.bitvise.com/tunnelier Bitvise Tunnelier]. Complete Login & C2S Forwarding tab in Bitvise.

* Login tab
** Host = hostname or IP address of your SSH server
** Port = 22
** Username = user name on SSH server
** Password = user name password on SSH server
* C2S Forwarding tab (select Add)
** Status = enabled
** Listen Interface = 127.0.0.1
** List. Port = 3307
** Destination Host = hostname or IP address of MySQL server (mine was private IP address as I connect to public IP from Login tab then forward to private IP)

On Linux clients use terminal.
<pre>$ ssh -v -f -N -L 3307:192.168.1.2:3306 username@hostname_of_mysql_server</pre>

Launch your MySQL client.

Your MySQL client should connect to localhost or 127.0.0.1 over port 3307 (or any port you used in ssh command above).

Your local machine will accept port 3307 traffic and forward that to MySQL server over secure encrypted SSH tunnel. SSH server will perform TCP forwarding of your 3307 port to 3306 on MySQL server.

<center>[[My db-class.org notes|To My db-class.org notes]]</center>