Friday, September 21, 2012

How to setup mySQL SSH Tunnel using Putty?

1. Configure your SSH server configuration as shown in the screen below:


2. Click on Connection -> SSH -> Tunnels, enter 

Source Port: 3307
Destination: localhost:3306

3. Once "Add" button is clicked, the screen as shown below is displayed. Click "Open" button to connect to your server, enter your SSH login name and password.



4. Once connected, open your mysql browser to connect to localhost with port 3307.





Tada! Here you get into your mysql database through SSH tunnel.