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.
See: http://www.chiark.greenend.org.uk/~sgtatham/putty/
Joachim.
You need:
MySQLcc: http://www.mysql.com/downloads/mysqlcc.html
Putty: http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe
And a hosting provider with SSH enabled!
Open putty.exe.
Specify the host name or IP of your site. Click on the "SSH" radio button.
Go to the settings Connection > SSH > Tunneling
Add new forwarded port:
Source port: 3306
Destination: localhost:3306
Click on the "Local" radio button.
Click "Add"
Go back to Session settings, type a name for Saved session and click "Save". Then click "Open"
You will be asked for login and password. Enter them.
On MySQLControlCenter, go to File > New, type a Name for your connection. Then at host name type
localhost
Then your user name and password in the following fields.
Click "Add", then double click on the new server icon to connect!
At my computer I have local instalation of mysql and mysqld uses the 3306 port so I have to choose different port for mysql connection:
My settings for example are:
Add new forwarded port:
Source port: 4000
Destination: localhost:3306
Click on the "Local" radio button.
Click "Add
When you conect to mysql client use localhost:4000 port.
Source port is arbitrarry port greater then 1024 only take in account that some application could use.