Database

A MySQL database service is available on the Shell Server

For other database requirements, please contact the Systems Administrators

MySQL (on nightmare)

This section describes how to setup your MySQL database on the shell server.

  1. SSH into the Shell Server

  2. Create your mysql database, username and password by running the following command:

    mysqluser

This should output something similar to the following which includes your database name, username and password:

MySQL:
hostname: nightmare.cs.uct.ac.za
database: smtdoe004
username: smtdoe004
password: wohgefee
You can set your new password with:

mysql --user=smtdoe004 --password=wohgefee smtdoe004
mysql> set password=password('your new pass');
mysql> quit

Note

Take note of hostname, database, username and password for all future use.

Note

If you forget the password, just re-run mysqluser and it will give you a new random password without deleting your existing database.