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.
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.
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
mysql command interface
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.
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
MySQL client applications are installed on Linux and Windows systems in the School.
The School's MySQL databases can be accessed from
MySQL Workbench installed on your own
workstation or laptop.
You can write programs that connect to the School's MySQL databases.
phpMyAdmin is a web-based application where you can log in and view and
administer your MySQL database.
There is a sample database, which is used in the other Notes, that you can use to try MySQL.