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.
Key Features
- User-friendly interface (extensive employment of JavaScript).
- 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.
Website: www.adminer.org
Support: Forums, GitHub Code Repository
Developer: Jakub Vrana
License: Apache license or GNU General Public License v2.0
Adminer is written in PHP. Learn PHP with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |