Database connection information:

Database name: ******
Username: *******
Password: *******
Host: bender.cs.unm.edu

Database connections are only allowed from the CS network, for example, from 
moons.cs.unm.edu (the CS lab) and trucks.cs.unm.edu. You will not be able to connect to 
your database from outside of the CS network. See below for instructions on how to connect 
to the database from a computer that is not directly connected to the CS network.

Here are two way to connect to your database:

1) Via the web interface at https://bender.cs.unm.edu/phpMyAdmin
Choose the your database from the list of databases on the left 

2) Via the mysql command line on moons or trucks:
mysql -u username -h bender.cs.unm.edu -p 

You can view your web pages / php output at https://bender.cs.unm.edu/~username

You will not be able to ssh to bender. 4 weeks after the semester ends, we will be deleting all 
of the student databases on bender, so be sure to grab any data that you want to keep.

If you are connecting to the database from a location that is not connected to the CS network, 
we recommend using SSH port forwarding or the CS VPN :

You can connect to web interface using ssh port forwarding:

1) Set up port forwarding. On your local machine (not trucks, not moons) enter the following 
command in a terminal window that has been opened on your local machine. This sets up 
port forwarding. 

ssh -L 4430:bender.cs.unm.edu:443 your_cs_username@trucks.cs.unm.edu

This will log you into a CS machine, and does not log you into bender. Use your CS username 
/ password in this step. Do not enter your database username / password

This command will forward the local source port 4430 on your local machine to 
bender.cs.unm.edu:443

2) On your local machine, open a web browser

3) In that web browser put in the following URL:

https://localhost:4430/phpMyAdmin/

4) Your web browser will prompt you for a username / password. Enter in your database 
username and password

Step 1 is specific to OS X and Linux. Since I don't use Windows, I can't give specific 
instructions for that platform. A quick google for "port forwarding putty" turns up the 
following:

http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html

These same steps will work for forwarding port 3360 (the MySQL port), for example:

ssh -L 3360:bender.cs.unm.edu:3360 your_cs_username@trucks.cs.unm.edu

Then you'll be able to connect to localhost:3360 for your mysql connection.