Adminer (formerly known as phpMinAdmin) is a full-featured tool for managing content in MySQL databases.
Unlike phpMyAdmin, Adminer consists of a single file ready to deploy to the target server. It is a lightweight alternative which still offers a good feature set.
Adminer is free and open source software.
- Connect to a database server with username and password.
- Select an existing database or create a new one.
- List fields, indexes, foreign keys and triggers of table.
- Change name, engine, collation, auto_increment and comment of table.
- Alter name, type, collation, comment and default values of columns.
- Add and drop tables and columns.
- Create, alter, drop and search by indexes including fulltext.
- Create, alter, drop and link lists by foreign keys.
- Create, alter, drop and select from views.
- Create, alter, drop and call stored procedures and functions.
- Create, alter and drop triggers.
- 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 of databases and tables (its structures and/or data) as a dump to output or a downloadable attachment to SQL or CSV.
- Alter export for projecting changes to production database.
- 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).
- Extensive customization options.
- Visual database/E-R schema editing.
- SQL syntax highlighting.
- XHTML 1.1 validity in UTF-8.
- Very small footprint.
- Users log in specifying the destination server and providing the user name and password (which is stored during whole session).
- Text area for arbitrary SQL commands and storing these commands in command history
- Multiple language support (English, German, Spanish, Dutch, French, Italian, Estonian, Chinese, Czech, Slovak, Russian).
- Provisions against XSS, CSRF, SQL injection, session stealing
- Light-weight – released in a form of a single file, with support of CSS skins
- Available in Arabic, Catalan, Chinese, Czech, Dutch, English, Estonian, French, German, Hungarian, Italian, Japanese, Polish, Portuguese, Russian, Slovak, Slovenian, Spanish, Tamil, and Turkish.
|New to Linux? Read our Linux for Starters series.|
|The largest compilation of the best free and open source software in the universe. Supplied with our legendary ratings charts.|
|Hundreds of in-depth reviews offering our unbiased and expert opinion on software.|
|Alternatives to Google's Products and Services examines your options to migrate from the Google ecosystem with open source Linux alternatives.|
|Essential Linux system tools looks at small, indispensable utilities, useful for system administrators as well as regular users.|
|Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine.|
|Home computers became commonplace in the 1980s. Emulate home computers such as the ZX81, Amstrad CPC, and ZX Spectrum.|
|Now and Then examines how promising open source software fared over the years.|
|Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged.|
|Linux Candy opens up to the lighter side of Linux. Have some fun!|
|Best Free Android Apps. There's a strict eligibility criteria for inclusion in this series|
|These best free books accelerate your learning of every programming language|
|These free tutorials offer the perfect tonic to the free programming books series|
|Stars and Stripes is an occasional series looking at the impact of Linux in the USA|