This section describes how to get an encrypted connection to a remote MySQL server with SSH. The information was provided by David Carlson <dcarlson@mplcomm.com>
.
-
Install an SSH client on your Windows machine. For a comparison of SSH clients, see http://en.wikipedia.org/wiki/Comparison_of_SSH_clients.
-
Start your Windows SSH client. Set
Host_Name =
. Setyourmysqlserver_URL_or_IP
userid=
to log in to your server. Thisyour_userid
userid
value might not be the same as the user name of your MySQL account. -
Set up port forwarding. Either do a remote forward (Set
local_port: 3306
,remote_host:
,yourmysqlservername_or_ip
remote_port: 3306
) or a local forward (Setport: 3306
,host: localhost
,remote port: 3306
). -
Save everything, otherwise you will have to redo it the next time.
-
Log in to your server with the SSH session you just created.
-
On your Windows machine, start some ODBC application (such as Access).
-
Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except type in
localhost
for the MySQL host server, notyourmysqlservername
.
At this point, you should have an ODBC connection to MySQL, encrypted using SSH.