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)
  • Indeed a very useful script. Stable and fast, and certainly this kind of infrastructure of open source software perfect for preparation.

    Announced that everyone Thank you so much for your help.

  • Version 2.0 was released today – see http://www.adminer.org/en/

  • Tom

    Perfect! Simple & so so fast … its just amazing! Big cheers WRD for sharing …

  • nice! thanks for the data!

  • Wonderful php script. You truly have saved me a lot of time and aggravation. Wonderful Job!

  • Thanks alot,

    very good php software

  • Chris

    This is a really useful script. So easy to install and use. Since ISP cut off external access to MYSQL4 it has been a lifeline

    many thanks