Administering MySQL Databases with phpMyAdmin

phpMyAdmin 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

Administering your MySQL Database through the Web with phpMyAdmin

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 Go button 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.

Click on 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. Click Go to insert the row(s).

There's a 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 Go button.

Scroll the create table panel down to reveal the Save button. Click the left mouse button on Save to create the table.

You can insert rows into the new table using the Insert tab, or from a file using the Import tab.

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 the Home icon in the left side menu.