The Specification of the Database Server for CS4421

Spring 2012

· Server Name: orion.csl.mtu.edu

· OS: FC13

· DBMS: MySQL 5.1.45

Databases and Accounts:

Each student has account and a database on the server.

The account name, password and the database name are all same as your account name on the lab machines.

You should change your password as soon as you can.

MySQL client tools

In the CS lab, there are three ways to access the database

1. Use command line tool mysql

% mysql -h orion.csl -uuid -p

mysql> quit

% mysql -h orion.csl -uuid -p defaultdatabase

2. Use web tool phpMyAdmin

open http://orion.csl.mtu.edu/phpMyAdmin/

type in your database username and password

3. Use MySql Workbench

%mysql-workbench

You can do QUERY, model and Database administrator work

          Other tools

Dbartisan

                        Toad

WinSQL

Note: to use mysql-workbench is available on Windows. You may install it on your personal computer.

How to change password:

mysql> set password=password("cs4421");

MySQl tutoring link:

Tutoring link: http://dev.mysql.com/doc/refman/5.1/en/tutorial.html

More reference link: http://dev.mysql.com/doc/refman/5.1/en/

Personal web page

Under your home directory, create a directory named .WWW-orion (don’t forget the starting . ) with read and executable permission to the other users.

Then put your files under .WWW-orion with appropriate permission.

Your personal web page can be accessed with url http://orion.csl.mtu.edu/~uid

PHP

PHP version 5.3.2 is installed and enabled to use with Apache 2.0, the web server.

Check http://orion.csl.mtu.edu/~ruihong/test.php for details.

JDBC

$CLASSPATH should contain the Mysql Java connector driver /usr/share/java/mysql-connector-java.jar