Adminer / News: Recent posts

Adminer 3.3.0 released

Use Esc to disable in-place edit
Shortcut for database privileges
Editable index names
Append new index with auto index selection (bug #3282127)
Preserve original timestamp value in multiple update (bug #3312614)
Bit type default value
Display foreign key name in tooltip
Display default column value in table overview
Display column collation in tooltip
Keyboard shortcuts: Alt+Shift+1 for homepage, Ctrl+Shift+Enter for Save and continue edit
Show only errors with Webserver file SQL command
Remember select export and import options
Link tables and indexes from SQL command EXPLAIN (MySQL)
Display error with all wrong SQL commands (MySQL)
Display foreign keys from other schemas (PostgreSQL)
Pagination support (Oracle)
Autocomplete for big foreign keys (Editor)
Display name of the referenced record in PostgreSQL (Editor)
Prefer NULL to empty string (Editor, bug #3323800)
Display searched columns (Editor)
Customizable favicon (customization)
Method name can return a link (customization)
Easier sending of default headers (customization)
Romanian translation... read more

Posted by Jakub Vrána 2011-07-19

Compare Adminer and phpMyAdmin - presentation

Adminer (in direct comparison with phpMyAdmin) was presented on O'Reilly MySQL Conference in a session Replace phpMyAdmin with Something Better:

Slides are available for download:

Posted by Jakub Vrána 2011-04-14

Adminer 3.2.1 released

Adminer 3.2.1 (released 2011-03-23):
Ability to save expression in edit
Respect default database collation (bug #3191489)
Don't export triggers without table (bug #3193489)
Esc to focus next field in Tab textarea (thanks to David Grudl)
Send forms by Ctrl+Enter on <select>
Enum editor and textarea Ctrl+Enter working in IE
AJAX forms in Google Chrome
Parse UTF-16 and UTF-8 BOM in all text uploads
Display ; in history (thanks to Jan Cerny)
Use DELIMITER in history
Show databases even with skip_show_database in MySQL 5 (thanks to Radoslaw Kowalewski)
Disable maxlength with functions in edit
Better placement of AJAX icon
Table header in CSV export (Editor)
Time format hint (Editor)
Respect order after search (Editor)
Set MySQL time zone by PHP setting (Editor)
Allow own code in <head> (customization)
Polish translation... read more

Posted by Jakub Vrána 2011-03-23

Adminer 3.2.0 released

Get long texts and slow information by AJAX
Most links and forms by AJAX in browsers with support for history.pushState
Copy tables
Ability to search by expression in select
Export SQL command result (bug #3116854)
Focus first field with insert (bug #3126501)
Permanent link in schema
Display total time in show only errors mode in SQL command
History: edit all
MS SQL: auto primary and foreign key
SQLite: display 0
Create table default data type: int
Focus upper/lower fields by Ctrl+Up/Ctrl+Down
Hide credentials for SQLite
Utilize oids in PostgreSQL
Homepage customization
Use IN for search in numeric fields (Editor)
Use password input for _md5 and _sha1 fields (Editor)
Work without session.use_cookies (bug #3138640)
Fix saving schema to cookie in Opera
Portuguese, Slovenian and Turkish translation... read more

Posted by Jakub Vrána 2011-02-24

Adminer supports plugins

Adminer offers a customization feature since version 2. It is very powerful but users can find difficult to create them. This is the main reason why plugins were published. They are simple reusable components enhancing or altering the behavior of Adminer.

There are currently plugins for XML export, HTML editor, uploading to filesystem and many more. You can easily create a new plugin and there is already also some user-contributed content.... read more

Posted by Jakub Vrána 2011-02-14

Adminer 3.1.0 released

TSV export and import
Customizable export
Option to show only errors in SQL command
Link to bookmark SQL command
Recognize $$ strings in SQL command (PostgreSQL)
Highlight and edit SQL command in processlist
Always display all drivers
Timestamp at the end of export
Link to refresh database cache (bug #3102451)
Support for virtual foreign keys
Disable XSS "protection" of IE8
Immunity against zend.ze1_compatibility_mode (bug #3089645)
Fix last page with empty result set
Arabic translation and RTL support
Dual licensing: Apache or GPL... read more

Posted by Jakub Vrána 2010-11-16

Adminer 3.0.1 released

It is mainly a bug-fix release:

Send the form by Ctrl+Enter in all textareas
Disable creating SQLite databases with extension other than db, sdb, sqlite
Ability to use Adminer in a frame through customization
Catalan translation
MS SQL 2005 compatibility
PostgreSQL: connect if the eponymous database does not exist

Posted by Jakub Vrána 2010-10-18

Adminer 3.0.0 released

Main changes in database management tool Adminer 3.0.0 are:

Drivers for MS SQL, SQLite, PostgreSQL, Oracle
Allow concurrent logins on the same server
Allow permanent login without customization
In-place editation in select
Foreign key options in Table creation
Treat binary type as hex
Show number of tables in server overview
Operator LIKE %%
Remember export parameters in cookie
Allow semicolon as CSV separator
Schemas, sequences and types support (PostgreSQL)
Autofocus username in login form
Allow to insert Tab in SQL textareas and send the form by Ctrl+Enter
Disable spellchecking in SQL textareas
Display auto_increment value of inserted item
Allow disabling auto_increment value export
Prefill auto_increment column name
Ability to jump to any page in select by JavaScript
Display comment in table overview
Link last page above data in select
Link table names in SQL queries
Hungarian, Japanese and Tamil translation
Defer table information in database overview to JavaScript (performance)
Big tables optimizations (performance)... read more

Posted by Jakub Vrána 2010-10-15

Adminer 2.3.2 released

Bug fix release:
Fix COUNT(*) link
Fix Save and continue edit

Posted by Jakub Vrána 2010-04-21

Adminer 2.3.1 released

Main changes:

Add Drop button to Alter pages (regression from 2.0.0)
Link COUNT(*) result to listing
Newlines in select query edit
Return to referer after edit
Respect session.auto_start (bug #2967284)

Posted by Jakub Vrána 2010-04-06

Adminer 2.3.0 released

Main changes in MySQL management tool Adminer 2.3.0 are:

Support for permanent login (customization required)
Search in all tables
Show status variables
Print sums in tables overview
Add Delete button to Edit page (regression from 2.0.0)
Print error summary in SQL command
Simplify SQL syntax error message
Show SQL query info if available
Delete length when changing type in alter table
Ability to check table prefix in export... read more

Posted by Jakub Vrána 2010-02-26

Adminer 2.2.1 released

Main changes in MySQL management tool Adminer 2.2.0 are:

Highlight current links
Improve concurrency
Move number of tables to DB info (performance)
Search by foreign keys (Editor)
Link new item in backward keys (Editor)

Posted by Jakub Vrána 2009-11-27

Adminer 2.2.0 released

Main changes in MySQL management tool Adminer 2.2.0 are:

Database list - bulk drop, number of tables
Enlarge field for enum and set definition
Display table links above table structure
Link URLs in select
Display number of manipulated rows in JS confirm
Set required memory in SQL command
Fix removed default in ALTER
Display whitespace in texts (bug #2858042)
ClickJacking protection in modern browsers
E-mail attachments (Editor)
Optional year in date (Editor)
Search operators (Editor)
Align numbers to right in select (Editor)
Move <h1> to $adminer->navigation (customization)
Rename get_dbh to connection (customization)... read more

Posted by Jakub Vrána 2009-10-20

Adminer 2.1.0 released

MySQL management tool Adminer (formerly phpMinAdmin) reached the 2.1.0 version. The main differences are:

Edit default values directly in table creation
Execute SQL file stored on server disk
Display EXPLAIN in SQL query
Compress export and import
Display column comments in table overview
Print ALTER export instead of executing it
Click on row selects it
Fix Editor date format
Fix long SQL query crash (bug #2839231)
Speedup of simple alter table
Traditional Chinese translation... read more

Posted by Jakub Vrána 2009-09-20

Adminer 2.0.0 released

MySQL management tool Adminer (formerly phpMinAdmin) reached the 2.0.0 version. The main features are Adminer Editor (stand-alone application for user-friendly data editing) and PHP customization. The list of other improvements are quite long too:

Create single column foreign key in table structure
Table relations (Editor)
Send e-mails (Editor)
Display images in blob (Editor)
Localize date (Editor)
Treat tinyint(1) as bool (Editor)
Divide types to groups in table creation
Link e-mails in select
Show type in field name title (thanks to Jakub Sochor)
Preselect now() for timestamp columns (thanks to paranoiq)
Clear history (thanks to paranoiq)
Prefill insert by foreign key searches
Print number of rows in SQL command
Remove Delete button from Edit page - use mass operation for it
Faster multiple update, clone and delete
Faster table list in navigation
Download version checker and syntax highlighting from HTTPS
Use HTML Strict instead of XHTML
Remove function minification in favor of performance and customization
Fix CSV import
Fix work with default values (thanks to Jiri Pospisil)... read more

Posted by Jakub Vrána 2009-08-18

Adminer 1.11.1 released

Adminer 1.11.1 has been released. It fixes an error with enable Filter extension.

Posted by Jakub Vrána 2009-07-03

Adminer (formerly phpMinAdmin) 1.11.0 released

MySQL management tool Adminer 1.11.0 contains lots of improvements mainly in the usability. Among others, these changes include:

Simplify export
Display execution time in SQL query
Version checker
Save queries to history and display it on SQL page
Always try to use the syntax highlighter
Automatically add new fields in table creation

Please look at for a full list of important changes or go to to download the new version.

Posted by Jakub Vrána 2009-07-02