From phpMyAdmin Devel Team
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 55 languages. GPL License information.
phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you will need a properly set up MySQL user who can read/write only the desired database. It is up to you to look up the appropriate part in the MySQL manual.
Currently phpMyAdmin can:
* browse and drop databases, tables, views, fields and indexes
* create, copy, drop, rename and alter databases, tables, fields and indexes
* maintenance server, databases and tables, with proposals on server configuration
* execute, edit and bookmark any SQL-statement, even batch-queries
* load text files into tables
* create1 and read dumps of tables
* export1 data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel and LATEX formats
* administer multiple servers
* manage MySQL users and privileges
# bug #2941037 [core] Database structure not sorted by table correctly
# bug #2948492 [interface] Slide effect masks some fields on search page
# bug #2959746 [interface] Unknown table status: TABLE_TYPE
# bug #2953050 [export] export VIEW as SQL includes INSERT statement
# bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
# bug #2961609 [auth] Potential information disclosure at login page
# patch #2961540 [export] Do not export data of MERGE table, thanks to Dieter Adriaenssens - ruleant
# bug #2961198 [parser] Querying a table named "data"
# bug #2931429 [structure] Editing long triggers
# bug #2970769 [structure] Incorrect reference to mootools-more.js
- You need PHP 5.2.0 or newer, with session support (see FAQ 1.31) and the Standard PHP Library (SPL) extension.
- MySQL 5.0 or newer