Type the source port you want to reference locally and Destination values make sure to also check the boxes as the following image shows before clicking the “Add” button: With the session that you just created selected, click the 'Tunnels' option under the 'SSH' tab to the left. Don’t forget to give a name to the session and save it: Open PuTTY and fill out the 'Host Name' box with your server and the SSH port to connect to it. We will use Putty which is a free tool that will help us to accomplish our goals in this tutorial. Tunneling is a technique that consist on creating a connection between your PC and a server and make it appear as if the remote MySQL database you’re accessing through the tunnel is locally running from your machine. For the first part of this tutorial, please refer to How to: Guide to install and configure SSH in a MySQL server on Windows.
This is the second part of the complete Guide to install and configure SSH in a MySQL server on Windows tutorial, we will cover how to create the tunnel from the client using putty. If you have any questions regarding the following post, please share them with us at: MySQL For Excel ForumĬreating a SSH tunnel to MySQL using PuTTY This section describes how to get a secure connection to a remote MySQL server with SSH.
