phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW.

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW.

Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin can manage a whole MySQL server as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual.

Here are some key features of "phpMyAdmin":

· create and drop databases
· create, copy, drop, rename and alter tables
· do table maintenance
· delete, edit and add fields
· execute any SQL-statement, even batch-queries
· manage keys on fields
· load text files into tables
· create (*) and read dumps of tables
· export (*) data to CSV, XML and Latex formats
· administer multiple servers
· manage MySQL users and privileges
· check referential integrity in MyISAM tables
· using Query-by-example (QBE), create complex queries automatically connecting required tables
· create PDF graphics of your Database layout
· search globally in a database or a subset of it
· transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link or ...
· support InnoDB tables and foreign keys (see FAQ 3.6)
· support mysqli, the improved MySQL extension (see FAQ 1.17)
· communicate in 47 different languages