phpMyAdmin is a very useful tool created to handle the adminstration of MySQL over the web.
Currently it can create and drop databases, create/drop/alter tables, execute any SQL statement, delete/edit/add fields, manage keys on fields.
Here are some key features of "phpMyAdmin":
· Create and drop databases.
· Create, copy, drop and alter tables.
· 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 values.
· Administer multiple servers and single databases.
Requirements:
· PHP 5.2 or later
· MySQL 5.0 or later
What's New in This Release: [ read full changelog ]
· browse-mode improvements
· grid editing
· remember recent tables
· remember last sort order by table
· flexible column width
· reorder columns
· more compact navigation bar
· AJAXification of many operations
· reorganised server status page, with server monitoring
· improved support for stored routines, events and triggers
· openGIS support
· zoom-search in table search
· Drizzle support
· improved ENUM/SET editor