Web Site and Database Installation

Registration

You have been given a Unix Login (e.g. cs34130) - this will be called MYLOGIN below.

Make up your own Database Password (e.g. mysecret) - this will be called MYPASSWORD below. If you like, this password may be the same as your Unix Password. It's up to you.

Register MYLOGIN and MYPASSWORD for your own database: register.html

Installation Login to your Unix account.

In .login, search for the word rlogin and put this command before the rlogin comment: 

source ~billard/setjava1.2

Run this script: 

 ~billard/public_html/SQL/SQL-install

At the end, the script will instruct you to make a special MYPASSWORD directory for your own HTML work. 

 cd public_html
 mv SQL MYPASSWORD
 For example: mv SQL mysecret

This directory is private and the only way to browse this directory is by using MYPASSWORD: 

http://gold.mcs.csuhayward.edu:8080/~MYLOGIN/MYPASSWORD/student.html
For example: http://gold.mcs.csuhayward.edu:8080/~cs34130/mysecret/student.html

Database Access

After the instructor creates all databases, you can access your own database: 

unix% mysql -pMYPASSWORD -u MYLOGIN -h gold MYLOGIN
For example: mysql -pmysecret -u cs34130 -h gold cs34130
show tables;
\q

Your Unix ID (MYLOGIN) is now your User ID for the database, and the name of the database itself.