MySQL in the School of Computer Science & Informatics

MySQL is “the world's most popular open source database”. Users in Cardiff School of Computer Science & Informatics can have a MySQL database account on the School's general MySQL server, csmysql.cs.cf.ac.uk.

This Note tells you about your School MySQL account and what you need to know to connect client applications and programs to the MySQL server.

There are links to other Notes that describe how to use MySQL in more detail.

Accounts and Databases on the MySQL Server

To use MySQL, you must have an account and database on a MySQL server. Students pursuing appropriate courses in Cardiff School of Computer Science & Informatics will have an account created as part of their coursework. You will be sent details of the account before your coursework begins. Other users can request an account from the School's computer systems managers.

The accounts are on the MySQL server csmysql.cs.cf.ac.uk. The server is running MySQL version 5.1.73.

When your account is created, you will be given a user name, MySQL password and a database name. The user name for your MySQL account will be, in general, the same as your usual one but you will have a distinct password. (You should NOT set the MySQL password to be the same as your other account passwords). For coursework, your database name will be the same as your user name. For other work, you can suggest any name for the database but a different name may be allocated – the names need to be unique among all users.

Accessing MySQL

MySQL databases can be accessed from SQL (Structured Query Language) client applications and interfaces that are available on many different platforms and for several languages.

This Note does not describe the SQL language used in MySQL. See the documentation for MySQL 5.1 at http://dev.mysql.com/doc/refman/5.0/en/ instead.

Two MySQL applications which are available on the Schools Windows and Linux laboratory workstations are

the mysql command interface

and the MySQL Workbench application.

Your MySQL database can be accessed from programs using appropriate MySQL APIs.

The School also has a phpMyAdmin web application interface that lets you adinister your MySQL database using a web browser.

Other Notes about MySQL

There are Notes with information about accessing your MySQL database from the School's computing platforms and from home systems, and about writing programs to access MySQL, and about using phpMyAdmin.

MySQL from the School's Platforms

MySQL client applications are installed on Linux and Windows systems in the School.

MySQL from Outside the School

The School's MySQL databases can be accessed from MySQL Workbench installed on your own workstation or laptop.

Programs that Connect to MySQL

You can write programs that connect to the School's MySQL databases.

phpMyAdmin

phpMyAdmin is a web-based application where you can log in and view and administer your MySQL database.

The Sample Database

There is a sample database, which is used in the other Notes, that you can use to try MySQL.