Connecting to MariaDB Remotely from Windows with SSH
This section describes how to get a secure connection to a remote MariaDB server with SSH. The information was provided by David Carlson <dcarlson@mplcomm.com>
.
- Install an SSH client on your Windows machine. As a user, the best nonfree one I have found is from
SecureCRT
from http://www.vandyke.com/. Another option isf-secure
from http://www.f-secure.com/. You can also find some free ones onGoogle
at http://directory.google.com/Top/Computers/Internet/Protocols/SSH/Clients/Windows/. - 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 MariaDB 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 MariaDB using the ODBC driver the same way you normally do, except type in
localhost
for the MariaDB host server, notyourmysqlservername
.
At this point, you should have an ODBC connection to MySQL, encrypted using SSH.