Craig: Created page with " 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 applic..."

2015-04-02T12:03:50Z

Created page with " 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 applic..."

New page

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

Databases - Revision history

Craig: Created page with " 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 applic..."