From: "Aaron Parecki" Date: October 3, 2007 2:56:24 PM PDT To: cwilson@cs.uoregon.edu Subject: port forwarding for mysql Good SQL clients: Mac: http://cocoamysql.sourceforge.net Windows: http://www.webyog.com > From a terminal, log in to ix, and start tcp forwarding (change 3602 to the port your mysql instance is running on) ssh -L 3306:127.0.0.1:3602 username@ix.cs.uoregon.edu This is also possible in Putty. Here is a screenshot: http://martybugs.net/smoothwall/images/putty2.png. You would enter Source Port: 3306 and Destination: 127.0.0.1:3602. This tells your computer to forward any connections on port 3306 to ix, on port 3827. It is important to enter 127.0.0.1, NOT localhost. In the SQL client, use the following settings: Host: 127.0.0.1 (NOT localhost) User: your cs username Password: your password you entered when installing mysql Port: 3306