Skip to site navigation

Web support banner

The MySQL database service

Information Services Division runs a MySQL database server (release 5.6.14), intended for the use of departmental web developers, primarily through the use of PHP web pages. MySQL is a widely used relational database system, available under the GNU General Public Licence (GPL). It supports ANSI SQL with some extensions.

Full details can be found at www.mysql.com.
MySQL documentation can be found in the MySQL manual.
See also the MySQL Service Definition (PDF).

Eligibility and registration

Separate registration is necessary to establish a MySQL account. All departmental web accounts (ie ****www and ****w3*) are eligible for MySQL accounts on request. (If you do not have a departmental web account, you should apply to the UCL Web Unit - email web-support@ucl.ac.uk.) The MySQL account name must be the same as the UCL userid of the owner. To request an account, email mysql-support@ucl.ac.uk giving the required account name.

We will then create a MySQL account with your userid, and create an empty database, whose name will also be your userid. The account will have full privileges on this database, and will also be able to create new databases whose names begin with the userid. We will also create a less privileged user account, with the name ending in "_user", for example ucabwww_user - this account will have access to the same database, but with only (SELECT, INSERT, UPDATE, DELETE, EXECUTE) privileges. For security reasons, we recommend that you use this less privileged account in scripts and PHP web pages that will be used by end-users. The passwords for the two accounts will be e-mailed to you, and you should immediately change the passwords using the MySQL password change form.

Access methods

The server is mysql-server.ucl.ac.uk. You will be able to connect to it and manipulate data in the tables in your databases from any machine, using the following access methods:

For all queries about the MySQL Service email mysql-support@ucl.ac.uk.

Page last modified on 12 jun 14 11:52