Databases

The following database services are available:

• MySQL
• Microsoft SQL Server

These are available for use in the Database courses, as well as for backends to other applications developed as part of a CS teaching or research project.

MySQL

To create your personal database ssh into the Shell server and run the mysqluser command.

If you do not already have a database the mysqluser command will create one for you. Read the output of the command carefully as it contains information you will need to access the database including:

• Username
• Password
• Database name
• Server hostname
• The command to use to access the database.

If your database already exists running the mysqluser command will reset your password and output your database details. It will _not_ delete the database. If you want to clean out your database for a new application you should drop the tables you no longer require.

The mysql client (just called mysql) is installed on all of the Computer laboratory workstations as well as the Shell servers.

Consult documentation on the MySQL web site for information on the SQL language.

A database service is provided for