Adminer
Encyclopedia
Adminer is a tool for managing content in MySQL
databases. Adminer is distributed under Apache license
in a form of a single PHP
file (currently approx. 160 KiB in size). Its author is Jakub Vrána who (during 2007) decided to develop such tool as an "light-weight" alternative to phpMyAdmin
. Also, first webhosting providers started to include Adminer as MySQL managing tool into their portfolio of services.
The small single file is a result of compilation and minification of source codes.
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
databases. Adminer is distributed under Apache license
Apache License
The Apache License is a copyfree free software license authored by the Apache Software Foundation . The Apache License requires preservation of the copyright notice and disclaimer....
in a form of a single PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
file (currently approx. 160 KiB in size). Its author is Jakub Vrána who (during 2007) decided to develop such tool as an "light-weight" alternative to phpMyAdmin
PhpMyAdmin
phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and...
. Also, first webhosting providers started to include Adminer as MySQL managing tool into their portfolio of services.
Features
- Users log in specifying the destination server and providing the user name and password (which is stored during whole session)
- Basic functions: select databaseDatabaseA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
, select/edit tables, browse/insert/edit table rows - Searching or sorting via multiple columns
- Editing of other database objects: viewsView (database)In database theory, a view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document-oriented database composed of the result set of a query or map and reduce functions...
, triggers, eventEvent (computing)In computing an event is an action that is usually initiated outside the scope of a program and that is handled by a piece of code inside the program. Typically events are handled synchronous with the program flow, that is, the program has one or more dedicated places where events are handled...
s, stored procedureStored procedureA stored procedure is a subroutine available to applications that access a relational database system. A stored procedure is actually stored in the database data dictionary.Typical uses for stored procedures include data validation or access control mechanisms...
s, 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 interface (extensive employment of JavaScriptJavaScriptJavaScript is a prototype-based scripting language that is dynamic, weakly typed and has first-class functions. It is a multi-paradigm language, supporting object-oriented, imperative, and functional programming styles....
) - Multiple language support (English, German, Spanish, Dutch, French, Italian, Estonian, Chinese, Czech, Slovak, Russian)
- SQLSQLSQL is a programming language designed for managing data in relational database management systems ....
syntax highlightingSyntax highlightingSyntax highlighting is a feature of some text editors that display text—especially source code—in different colors and fonts according to the category of terms. This feature eases writing in a structured language such as a programming language or a markup language as both structures and... - Visual database/E-R schema editing
- XHTMLXHTMLXHTML is a family of XML markup languages that mirror or extend versions of the widely-used Hypertext Markup Language , the language in which web pages are written....
1.1 validity in UTF-8UTF-8UTF-8 is a multibyte character encoding for Unicode. Like UTF-16 and UTF-32, UTF-8 can represent every character in the Unicode character set. Unlike them, it is backward-compatible with ASCII and avoids the complications of endianness and byte order marks... - Countermeasures against XSSCross-site scriptingCross-site scripting is a type of computer security vulnerability typically found in Web applications that enables attackers to inject client-side script into Web pages viewed by other users. A cross-site scripting vulnerability may be used by attackers to bypass access controls such as the same...
, CSRF, SQL injectionSQL injectionA SQL injection is often used to attack the security of a website by inputting SQL statements in a web form to get a badly designed website in order to dump the database content to the attacker. SQL injection is a code injection technique that exploits a security vulnerability in a website's software...
, session stealing, … - "Light-weight" - released in a form of a single file, approx. 160 KiB in size, with support of CSSCSS-Computing:*Cascading Style Sheets, a language used to describe the style of document presentations in web development*Central Structure Store in the PHIGS 3D API*Closed source software, software that is not distributed with source code...
skins
The small single file is a result of compilation and minification of source codes.