USING MySQL Workbench

MySQL Workbench is GUI program that help manipulating databases. I have found it somewhat helpful even though it has bit of a learning curve. It is able to run on your home machine and access the database on the mountain via an SSH tunnel.
Setting Up the Tunnel
MySQL uses port 3306 to communicate. Open a terminal window and type in the following command: 
ssh -L 3306:localhost:3306 username@140.252.58.9
Where username is whatever you log in as and pima is stup

Setting Up the Workbench

Fire up the workbench and on the front page Click the circled "+" sign to create a new MySQL connection. Fill out the form with the following: 
Name: pima (or a name of your choosing) 
Username: rct
Hostname: 127.0.0.1
Port: 3306
Connection Method: Standard (TCP/IP)
Then press the Test Connection button and it will pop up a warning about an incompatible protocol. Ignore it and press Continue Anyway. Hopefully it will then respond with Success.

Running Simple Query

Click on the connection to fire up the screen and you should get something like this.

I have picked the Organization Table and moused over it and it pops up a list with an "I" and "Wrench" and a "Table". Clicking the "Table" pops up the Query (see near the Read line. 

SELECT * FROM observatory.Organization;
And generates the table below. You can save the table as an Excel Spreadsheet by Export and Import tools. You can edit this query if you like and press the Lightning symbol near the Green arrow.

WARNING: I think you cannot damage or change anything in the database if you never press an Apply button. This is circled in RED on the above image.

E/R Diagram

If you are daring, you can generate the E/R Diagram of the database to do so: 
Go to top menu Select Database>>Reverse Engineer 
It will then pop up a Connection menu .. Click Next 
It will then pop up a Fetch menu .. Click Next 
Check the "Observatory" box  .. Click Next
Pops up Retrieve and Reverse Engineer ... Click Next
Pops up Select Objects ...............   Click Execute
Pops up Progress page ................   Click Next
Pops up Progress page ................   Click Finish
You should have a  rather messy E/R Diagram.
After re-arranging it should a bit like like this

Instructions Index