is a web application that can be used to administer MySQL databases.
In the School, the web site http://www.cs.cf.ac.uk/phpMyAdmin will give you access to your MySQL database on the School's MySQL server csmysql.cs.cf.ac.uk.
For information about the School's MySQL database server and to learn about your MySQL account and database schema, see MySQL in the School of Computer Science & Informatics
Connect a web browser to http://www.cs.cf.ac.uk/phpMyAdmin.
You will see a login form.
Enter your MySQL user name and password and click the
to log into your MySQL database on the School's server csmysql.
In the frame on the left, the tables in your database are listed. (If you have more than one database on the server, a list of them will appear first. Click on the name to choose your database.)
If you click on the name of a table in the left frame, the right frame lets you browse the contents of the table. Each row can be edited, copied or deleted.
If you click within the data in a row, you can edit the value inline. Click outside the field to
confirm the change, or press the
Escape key to camcel it.
There are also tabs for searching the table, inserting rows and for running arbitrary SQL commands.
Insert to get a form where you can enter
values for a new row.
The form has space for more new rows - you can use just one or many.
Go to insert the row(s).
Create table button in the menu on
the left. Click on it to add a new table to your database.
In the create table form on the right, type the name of the table and give names and
types to each of the columns. There's space for four columns, if you need more, put
the number is the
Add column(s) field and click its
Scroll the create table panel down to reveal the
Save button. Click the left mouse
Save to create the table.
You can insert rows into the new table using the
Insert tab, or from a file
The panel lets you browse your local computer for the file. There are different options for the format of the file, for example you can use a CSV (comma separated values) file.
You can also
Export a table or the entire database to a file on your local workstation.
When you have finished with
phpMyAdmin, click on the
Log out icon to the right of
Home icon in the left side menu.