Adminer

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin.

See: Features, Requirements, Skins, References

Download
v 4.8.1, 2021-05-14

Why is Adminer better than phpMyAdmin?

Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. See detailed comparison.

Adminer development priorities are: 1. Security, 2. User experience, 3. Performance, 4. Feature set, 5. Size.

Screenshots

Screencast about Adminer features and using plugins (19:31, by Igor Hlina)

Downloads

Adminer 4.8.1 (.php, 465 kB), English only (.php, 310 kB)
Adminer 4.8.1 for MySQL (.php, 356 kB), English only (.php, 208 kB)
Source codes (.zip, 785 kB), Current development version
Donate: Paypal, Patreon, Revolut
Latest stable version (use e.g. by wget): https://www.adminer.org/latest[-mysql][-en].php
Change log, blog
User contributed packages: Debian package, Arch Linux package, Wordpress plugin, Drupal module, Docker, Dockette, Joomla extension, Moodle plugin, TYPO3 extension, CMS Made Simple Module, Laravel, Laravel, Laravel, AMPPS, Electron, Jaxon
Adminer is also bundled with Nette Framework (which this site runs on).
Older versions

Features

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 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)
Schemas, sequences, user types (PostgreSQL)
Extensive customization options

Requirements

Works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, SimpleDB (plugin), Firebird (plugin), ClickHouse (plugin) - Improve your driver
Supports PHP 5, 7 and 8 with enabled sessions
Available in many languages (43) - Create a new translation
Free for commercial and non-commercial use (Apache License or GPL 2)

Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling security plugins (e.g. to require an OTP) or by customizing the login method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself).