SSH tunneling using PuTTY and MySQL-Front

1. Create session
   • hostname: any pgrad or ugrad SIT server e.g. grey.ug.it.usyd.edu.au or simply mysql.it.usyd.edu.au
   • NOTE - as mysql.it.usyd.edu.au is a pgrad server, ugrads should use a ugrad server in the hostname field otherwise nothing will work ;-)
   • protocol:SSH
   • Session name: mysql (e.g.)
2. Connection->SSH->Tunnels
   • Source Port: 13306
   • Destination: mysql.it.usyd.edu.au:3306
3. Remember to click the “Add” Button to add the forwarded port settings as given above.
4. Click on Session again and save the “mysql” session

MySQL-Front Setup setup

1. Install
2. Click the Connection Button under the File Menu
3. Hostname/IP should be localhost
4. Enter the correct username, password
5. The port is 13306 instead of the default 3306 shown
6. Enter your database name
7. Click save

Making a connection

1. Start PuTTY and connect with the "mysql" session using your normal login and password - congratulations, you now have an encrypted tunnel
2. Start MySQL-Front and click the connection button under the File Menu
3. Click connect and you should be connected

1. If you get a connection failed error message from MySQL-Front, recheck the settings in MySQL-Front
2. If PuTTY cannot connect - recheck your settings and make sure there is no local firewall blocking SSH