Connecting to firewalled DB

Here's how to use CocoaMySQL to look at the scores database.

1. Download and install CocoaMySQL from http://cocoamysql.sf.net/

2. Open a terminal/iterm/xterm and create a tunnel to the webserver:

% ssh user@backhand.upa.org -L13306:newupadb:3306

This line says ssh (secure shell) into backhand.upa.org and
forward all local traffic on port 13306 to port 3306 on newupadb
via backhand.upa.org.

newupadb is a hostname that backhand.upa.org knows about.

You should know your password.

3. Connect to newupadb through the tunnel opened in 2 with CocoaMySQL

When CocoaMySQL starts, use these values:

Host: 127.0.0.1
User: club2005
Password: xxxxxxxx
Port: 13306

Press Connect

4. Select the scores DB in the left side column, under Choose database...

5. Select a table

The main panel will show you options to view the Structure (table
definition), Content (the specific records), Custom Query (to test
your SQL) and Dumps (if you really really want the gobs of data).