phpMyAdmin

Currently phpMyAdmin can:

• 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


• 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 ...


• communicate in 42 different languages

(*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2).