MySQL in the School of Computer Science & Informatics Cardiff School of Computer Science & Informatics Documentation & Facilities Toggle navigation Home Documentation Software Services Contact 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. Accessing MySQL Databases from Linux Accessing MySQL Databases from Windows MySQL from Outside the School The School's MySQL databases can be accessed from MySQL Workbench installed on your own workstation or laptop. Accessing MySQL Databases from your own Laptop or Workstation Programs that Connect to MySQL You can write programs that connect to the School's MySQL databases. Accessing MySQL Databases with Java Accessing MySQL Databases with Perl Accessing MySQL Databases with PHP Accessing MySQL Databases with Python phpMyAdmin phpMyAdmin is a web-based application where you can log in and view and administer your MySQL database. Administering MySQL with phpMyAdmin The Sample Database There is a sample database, which is used in the other Notes, that you can use to try MySQL. MySQL Sample Database Overview Accounts and Databases on the MySQL Server Accessing MySQL Other Notes about MySQL MySQL from the School's Platforms MySQL from Outside the School Programs that Connect to MySQL phpMyAdmin The Sample Database Back to top Tags database mysql sql Tags database mysql sql Cardiff University is a member of the Russell Group of Universities Cardiff University is a registered charity No. 1136855 Copyright © Cardiff University Accessibility Feedback Cookies Privacy Policy Terms of Use
