What to do?

0. Open MySQL Reference Manual (make sure to check your MySQL version): http://dev.mysql.com/doc/mysql/en/index.html

1. SSH to dbase.cs.montana.edu using your esus account and password info

2. Login to the MySQL DBMS: mysql -u username -D userDBschema -p

3. Enter your password (from the paper slip I provided in the class)

Some basic commands:

Please, use your own DB schema for writing your SQL commands. To go to your own DB schema: use userDBschema

Note: Your own userDBschema is on the slip of paper I gave you with your password (usually, the same as your esus login).

To leave MySQL: quit

To change your password: SET PASSWORD = PASSWORD (’yourpasswordhere’);

To check version of you’re MySQL DBMS: SHOW VARIABLES LIKE "%version%";

NOTE: Your access to this server is not allowed from esus. If this causes problems, try SSH to web1.cs.montana.edu first, and then SSH to dbase.cs.montana.edu from web1.

For those who like to play – apache, php and phpmyadmin are installed.

Phpmyadmin is here: http://dbase.cs.montana.edu/phpmyadmin