Adminer (formerly known as phpMinAdmin) is a tool for managing content in databases. It natively supports
MySQL
MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...
,
MariaDB
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...
,
PostgreSQL,
SQLite
SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the m ...
,
MS SQL,
Oracle,
Elasticsearch
Elasticsearch is a search engine based on the Lucene library. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. Elasticsearch is developed in Java and is dual ...
and
MongoDB
MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Ser ...
. Adminer is distributed under
Apache license (or
GPL v2
The GNU General Public License (GNU GPL or simply GPL) is a series of widely used free software licenses that guarantee end users the four freedoms to run, study, share, and modify the software. The license was the first copyleft for general u ...
) in a form of a single
PHP
PHP is a general-purpose scripting language geared toward web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1993 and released in 1995. The PHP reference implementation is now produced by The PHP Group. ...
file (around 470 KiB in size). Its author is Jakub Vrána who started to develop this tool as a light-weight alternative to
phpMyAdmin
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.
His ...
, in July 2007. Adminer got some attention in 2008 when it made it to the CCA finals at
SourceForge
SourceForge is a web service that offers software consumers a centralized online location to control and manage open-source software projects and research business software. It provides source code repository hosting, bug tracking, mirroring ...
. Also, first webhosting providers started to include Adminer as MySQL managing tool into their portfolio of services. In 2012 Adminer got coverage on Linux.com for the second time. The project's priorities, according to its author, are (in this order): safety, user-friendliness, performance, functionality, and size.
Features
* Users log in specifying the destination server and providing the user name and password (which is stored during whole session)
* Basic functions: select
database
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...
, select/edit tables, browse/insert/edit table rows
* Searching or sorting via multiple columns
* Editing of other database objects:
views
A view is a sight or prospect or the ability to see or be seen from a particular place.
View, views or Views may also refer to:
Common meanings
* View (Buddhism), a charged interpretation of experience which intensely shapes and affects thou ...
,
triggers,
event
Event may refer to:
Gatherings of people
* Ceremony, an event of ritual significance, performed on a special occasion
* Convention (meeting), a gathering of individuals engaged in some common interest
* Event management, the organization of e ...
s,
stored procedures, processes, mysql variables, user permissions
* Text area for arbitrary SQL commands and storing these commands in command history
* Export of databases and tables (its structures and/or data) as a dump to output or a downloadable attachment
*
User-friendly
Usability can be described as the capacity of a system to provide a condition for its users to perform the tasks safely, effectively, and efficiently while enjoying the experience. In software engineering, usability is the degree to which a soft ...
interface (extensive employment of
JavaScript
JavaScript (), often abbreviated as JS, is a programming language that is one of the core technologies of the World Wide Web, alongside HTML and CSS. As of 2022, 98% of websites use JavaScript on the client side for webpage behavior, of ...
)
* Multiple language support (Arabic, Bengali, Catalan, Chinese, Czech, Dutch, English, Estonian, French, German, Greek, Hungarian, Italian, Indonesian, Japanese, Korean, Lithuanian, Persian, Polish, Portuguese, Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Tamil, Thai, Turkish, Ukrainian, Vietnamese)
*
SQL syntax highlighting
Syntax highlighting is a feature of text editors that are used for programming, scripting, or markup languages, such as HTML. The feature displays text, especially source code, in different colours and fonts according to the category of terms ...
* Visual database/
E-R schema editing
* Countermeasures against
XSS,
CSRF
Cross-site request forgery, also known as one-click attack or session riding and abbreviated as CSRF (sometimes pronounced ''sea-surf'') or XSRF, is a type of malicious exploit of a website or web application where unauthorized commands are submitt ...
,
SQL injection
In computing, SQL injection is a code injection technique used to attack data-driven applications, in which malicious SQL statements are inserted into an entry field for execution (e.g. to dump the database contents to the attacker). SQL in ...
,
session-stealing, ...
* "Light-weight" – released in a form of a single file
* Support of
CSS "skins", as well as many extensions
The small single file is a result of compilation and minification of source codes.
See also
*
Comparison of database tools
The following tables compare general and technical information for a number of available :Database administration tools, database administrator tools. Please see individual product articles for further information. This article is neither all-incl ...
*
phpMyAdmin
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.
His ...
*
MySQL
MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...
*
PHP
PHP is a general-purpose scripting language geared toward web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1993 and released in 1995. The PHP reference implementation is now produced by The PHP Group. ...
References
{{reflist
External links
Project homepageReview at Linux.com
Database administration tools
Free software programmed in PHP
Cross-platform software
Software using the Apache license
MySQL
MariaDB
PostgreSQL
SQLite
Oracle database tools
Microsoft database software