Mayfield Global Knowledge Center :: How do I connect to a MySQL database using MySQL Administrator via putty using SSH?

How do I connect to a MySQL database using MySQL Administrator via putty using SSH?

Download and run putty.exe.
From the Category pane, locate and click Tunnels.
For the Port forwarding options, type the Source port (the default port is 3306), then type the target domain and port number in the Destination field (e.g. mysql.yourdomain.com:3306). Click Add.
From the Category pane, locate and click Session.
In the Host Name field type your SSH host name. In the Port field type 22. Ensure that SSH is selected for the Protocol. In the Saved Sessions field type a descriptive name for your session (e.g. MySession) then click Save.
Select the newly created session then click Load. Click Open to connect to the host.
When prompted to add the server host key, click Yes.
Type your username and password when prompted.
Once you have successfully logged in, minimize the putty application then start MySQL Administrator.
In the Server Host field type localhost. Type 3306 in the Port field. Type your MySQL username and password then click OK.
Congratulations, you have successfully established a secured connection to your MySQL server via SSH.