Step 1: Enable Port Forwarding in Putty for MySQL SSH Application - MySQL

First, you need to enable port forwarding in Putty for MySQL purposes. To do this, follow the procedure below.

1. Launch Putty.

2. Go to Session; under "Category," enter the following required log-in information:

Host name: this is your hosting account SSH hostname (this is NOT your MySQL hostname). 

Port: This is your SSH port. Contact your web hosting company to find out which SSH port they use. The standard SSH port is 22, but some hosting companies use different ports.

Under Connection Type: Select "SSH"

For example, suppose you have the following SSH log-in for your website (from your hosting account):

hostname: yourwebsite.com

port: 22

connection type: ssh

3. Under Connection -- SSH - click Tunnels. This is where you will configure your port forwarding options. Fill in the data listed below.

• Source port: 3307
  
  
• Destination: yourmysqlserverhostname:3306
  
  
• Check " Local"
  
  
• Check " Auto"

Now click "Add."

For example, suppose your MySQL hostname is: codex345.extremehost.com

After clicking "Add," your options for controlling SSH port forwarding should look like the screen shot below.

4. Finally, after going through steps 1 to 3 above, click "Open." Putty will connect to your SSH server.

5.  Enter your SSH username and password.

6.  If you finally see the bash prompt that ends with "$", you have successfully connected to your SSH hosting server and enabled port forwarding.