GNU Info

(mysql.info)Windows and SSH

---

Next: Windows symbolic links Prev: Windows running Up: Windows

---

Enter node , (file) or (file)node

Connecting to a Remote MySQL from Windows with SSH
..................................................

Here is a note about how to connect to get a secure connection to remote
MySQL server with SSH (by David Carlson <dcarlson@mplcomm.com>):

   * Install an SSH client on your Windows machine.  As a user, the
     best non-free one I've found is from `SecureCRT' from
     `http://www.vandyke.com/'.  Another option is `f-secure' from
     `http://www.f-secure.com/'. You can also find some free ones on
     *Google* at
     `http://directory.google.com/Top/Computers/Security/Products_and_Tools/Cryptography/SSH/Clients/Windows/'.

   * Start your Windows SSH client.  Set `Host_Name =
     yourmysqlserver_URL_or_IP'.  Set `userid=your_userid' to log in to
     your server (probably not the same as your MySQL login/password.

   * 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 (Set `port: 3306',
     `host: localhost', `remote port: 3306').

   * Save everything, otherwise you'll have to redo it the next time.

   * Log in to your server with 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 -- not `yourmysqlservername'.

You should now have an ODBC connection to MySQL, encrypted using SSH.