SSH Client for Windows
Home Download Purchase Support Manual Screenshots Media About

You can connect the MySQL Server with the Private Shell SSH client

Note: the latest version of Private Shell includes the configuration wizard that adjusts settings for MySQL secure access quickly and easily

There are two main reasons to use Private Shell for tunneling MySQL connections:

  1. Security.
  2. Ability to interact with servers allowing local connections only.

The latter reason is the solution for database access from any location.

To tunnel a MySQL connection, you have to be able to connect to the server via SSH first. Read the Password Authentication and the Public Key Authentication (optional) topics.

If you'd like to connect to the MySQL server with MS Access or other applications supporting ODBC, you have to download and install the MySQL ODBC driver for Windows.

Configuring Private Shell

  1. In the profile settings click Tunneling
  2. Click New outgoing tunnel and create a tunnel with the following parameters:
  3. Outgoing tunnel for MySQL connection

  4. Connect to the server using this profile

Note:
You may clear "Permit connections from local host only" option to allow other computers on the network to connect to the database server. While it can be a great solution for connecting a remote workgroup, it can compromise the security system.

Configuring MySQL/ODBC driver

  1. Open "Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC)"
  2. Add new User DSN with "MySQL ODBC Driver" as a driver
  3. Set Host/Server name to "localhost"
  4. Make sure Private Shell is connected and click Test Data Source to verify that the connection is OK.

Important Note:
You must have Private Shell running and connected in order to use the tunneling feature. You may put Private Shell shortcut to the startup folder (e.g. "c:\Program Files\Private Shell\pshell.exe" --profile "Profile Name") and set the "Minimize to tray" option in the profile's settings.


Comment On This Topic:


Latest Version
Private Shell 3.3
New in 3.3



Monitor your servers and web sites 24x7x365

Related Tutorials: CVS and SSH, MySQL and SSH, SecureFTP: SFTP client, SSH client,
Comparison between PuTTY and Private Shell SSH clients

Copyright 2001-2016 (c) Imposant

SSH is a registered trademark and Secure Shell is a trademark of SSH Communications Security Corp (www.ssh.com)