Web-Based MySQL Management With Only 1 File: Adminer

Adminer is a phpMyAdmin-like MySQL management application which is only 1 file (PHP) that makes it so easy to install.

It is multilanguage with 11 ready-to-use language files & supports most PHP & MySQL versions (PHP 4.3+, MySQL 4.1+).

PHP MySQL Manager Script

Adminer can connect to local/remote MySQL databases, create new ones & complete almost every other database transactions like:

  • Create, alter, drop indexes/foreign keys/views/stored procedures & functions
  • List data in tables with search, aggregate, sort and limit results
  • Insert new records, update and delete the existing ones
  • Supports all data types, blobs through file transfer
  • Execute any SQL command from a text field or a file
  • Export table structure, data, views, routines, databases to SQL or CSV
  • Print database schema connected by foreign keys
  • Show processes and kill them
  • Display users and rights and change them
  • Display variables with links to documentation
  • Manage events and table partitions (MySQL 5.1)