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.
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
- complete a request for a web account form (pdf) and
- send this electronically to email@example.com.The MySQL account name must be the same as the UCL userid of the owner.
- To request a MySQL account, email firstname.lastname@example.org giving the required account name and explaining why you need the account, what data will be collected etc.
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.
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:
- From PHP code in web pages
- Using web pages created with Dreamweaver MX
- From a PC running Windows using ODBC - in particular, from Microsoft Access
- From phpMyAdmin interface - simply log in with your MySQL id and password (note this is now running the latest version: phpMyAdmin 220.127.116.11, if you have any comments or queries please email email@example.com)
- Using the mysql command-line tool and other Unix commands
- The MySQL Query Browser visual tool is available on Staff WTS
- From C programs on the Solaris Unix service
- From Perl scripts on the UCL web server
- From Tcl scripts on the Solaris Unix service
For all queries about the MySQL Service email firstname.lastname@example.org.