Adminer

Can be used as an alternative to phpMyAdmin, but it is easier to use because it consists of a single file ready to deploy to the server.

Adminer is available in Czech, Chinese, Dutch, English, Estonian, French, German, Italian, Russian, Slovak, Spanish and many other international languages.

Adminer was previously known as phpMinAdmin

What is new in this release:

• Fix XSS in alter table (found by HP Fortify).

What is new in version 4.2.1:

• Fixed handling of long text in SQL textarea.
• Support paste to SQL textarea in Opera.

What is new in version 4.2.0:

• Fixed handling of long text in SQL textarea.
• Support paste to SQL textarea in Opera.

What is new in version 3.7.0:

• Allow more SQL files to be uploaded at the same time
• Print run time next to executed queries
• Don't drop original view and routine before creating the new one
• Highlight default submit button
• Add server placeholder to login form
• Disable SQL export when applying functions in select
• Allow using lang() in plugins (customization)
• Remove bzip2 compression support
• Constraint memory used in TAR export

What is new in version 3.6.4:

• Respect PHP configuration max_input_vars
• Fix unsetting permanent login after logout
• Disable autocapitalize in identifiers on mobile browsers
• MySQL: Compatibility with MySQL 5.6
• MySQL: Move ALTER export to plugin
• MySQL: Use numeric time zone in export
• MySQL: Link processlist documentation
• SQLite: Export indexes

What is new in version 3.6.2:

• Edit strings with \n in textarea
• Time out long running database list and select count
• Use VALUES() in INSERT+UPDATE export
• Style logout button as link
• Store selected database to permanent login
• Ctrl+click and Shift+click on button opens form to a blank window
• Switch language by POST
• Compress translations
• MySQL: Support geometry data types

What is new in version 3.5.1:

• Autohide column context menu in select
• Autodisplay long table names in tables list
• Display assigned auto_increment after clone
• SQLite: Full alter table
• SQLite: Better editing in tables without primary key
• SQLite: Display number of rows in database overview

What is new in version 3.5.0:

• Links for column search in select
• Autohide column context menu in select
• Autodisplay long table names in tables list
• Display assigned auto_increment after clone
• SQLite: Full alter table
• SQLite: Better editing in tables without primary key
• SQLite: Display number of rows in database overview

What is new in version 3.4.0:

• Shift+click on checkbox to select consecutive rows
• Print current time next to executed SQL queries
• Warn about selecting data without index
• Allow specifying database in login form
• Link to original table in EXPLAIN of SELECT * FROM table t
• Format numbers in translations
• MySQL: inform about disabled event_scheduler
• SQLite: support binary data
• PostgreSQL: approximate row count in table overview
• PostgreSQL: improve PDO support in SQL command
• Oracle: schema, processlist, table overview numbers
• Simplify work with NULL values (customization)
• Use namespace in login form (customization)
• Customizable export filename (customization)
• Replace JSMin by better JavaScript minifier
• Don't use AJAX links and forms
• Indonesian translation
• Ukrainian translation
• Bengali translation

What is new in version 3.3.4:

• Foreign keys default actions
• SET DEFAULT foreign key action
• Fix minor parser bug in SQL command with webserver file
• Ctrl+click on button opens form to a blank window
• Trim table and column names
• Error message with no response from server in AJAX
• Esc to cancel AJAX request
• Move AJAX loading indicator to the right
• Don't quote bit type in export
• Don't check row while selecting text
• Fix invalid references line position on Database schema
• Disable selecting text on Database schema
• Ability to disable export (customization)
• Extensible list of databases (customization)
• MySQL: set autocommit after connect
• SQLite, PostgreSQL: vacuum
• SQLite, PostgreSQL: don't use LIKE for numbers
• PostgreSQL: fix alter foreign key
• PostgreSQL over PDO: connect if the eponymous database does not exist
• Boolean search (Editor)
• Persian translation

What is new in version 3.3.2:

• Display error with non-existent row in edit
• Fix minor parser bug in SQL command with webserver file
• Fix SQL command Stop on error
• Don't scroll with AJAX select order and alter move column
• Fast number of rows with big tables (PostgreSQL)
• Sort databases and schemas (PostgreSQL)

What is new in version 3.3.1:

• Fix XSS introduced in Adminer 3.2.0.
• Fix altering default values (PostgreSQL).
• Process list (PostgreSQL).

What is new in version 3.3.0:

• 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

What is new in version 3.2.2:

• Fixed AJAX history after reload.

What is new in version 2.3.2:

• Fix COUNT(*) link.
• Fix Save and continue edit.

Requirements:

• Works with MySQL 4.1 and 5.0 through mysqli, mysql or pdo PHP extension
• Supports both PHP 4.3+ and PHP 5 with enabled sessions