phpMyAdmin

phpMyAdmin has reached the stratosphere of fame in Web development, almost completely identifying itself with the product it serves.

Just by saying phpMyAdmin, any developer these days will think of MySQL. Some don't even know MySQL doesn't come with phpMyAdmin included and you need to install it separately.

Sure there might be other MySQL Web GUIs around, but almost all came after phpMyAdmin and most of them copy its interface and features without even giving it a second thought.

Basically phpMyAdmin is an unofficial standard for dealing with MySQL from your browser.

What is new in this release:

• Disabled storage engines
• Allow setting routine wise privileges
• Hide Insert tab for non-updatable views
• UI for defining partitioning in create table window
• Support JSON data type
• Editing partitions in table Structure
• Tracking does not make sense for information_schema
• Regression in Find and replace
• TokuDB Tables Show Size as "unknown"
• Use a slider for Internal relations
• Ability to disable the navigationhiding Feature
• Restrict configuration NavigationTreeDbSeparator to strings
• Disable the tooltip in the navigation panel's filter box
• Copy results to clipboard
• Reactivate cut&paste possibility in print view
• Extraneous message after edit + grid-edit
• Table header is empty with browsing an empty table
• Allow changing parameter order of routines
• Remove no password warning
• Clarify the meaning of "Stand-in structure for view" in SQL export
• HTML line break shown after a MySQL connection error message
• CSV import skip row count after
• Fixed displaying of SQL query on table operations
• Display binary strings as text if they are valid UTF-8
• Display routine specific privileges
• Copy multiple tables to database
• Support Cloudflare Flexible SSL
• Handle empty TABLE_COMMENT
• Drop support for old Internet Explorer versions
• Use modals for displaying forms in db structure page
• Show MySQL error messages in user language
• Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP >= 5.6
• Show more used PHP extensions
• Report when version check and error reporting are disabled
• Fix PDF schema export
• Remove ForceSSL configuration directive
• Remove support for Mozilla Prism
• Remove PmaAbsoluteUri configuration directive
• Fix autoloading of phpseclib
• Fixed rendering of missing extension error
• Errors on Structure tab when user only has select access on certain columns
• Missing documentation for $cfg['Servers'][$i]['favorite'] and $cfg['NumFavoriteTables']
• Avoid displaying UPDATE query twice
• Fixed CSV import
• Fix SQL syntax highlighting in database search page
• Fix error when we can not generate random string
• Fixed PHP syntax error in templates
• Fixed processing of queries with escaped quotes
• Fixed exporting tables with fields DEFAULT and COMMENT
• Hide edit and delete buttons when the results are not related to a table
• Fixed parsing of field definition
• Fixed rendering of table stats
• Fixed problems with PHP on Windows on table structure
• Like search strings being escaped incorrectly
• Rename exported databases/tables doesn't seem to work
• Undefined index: controllink
• PHP Fatal error: Call to undefined function __()

What is new in version 4.6.3:

• Disabled storage engines
• Allow setting routine wise privileges
• Hide Insert tab for non-updatable views
• UI for defining partitioning in create table window
• Support JSON data type
• Editing partitions in table Structure
• Tracking does not make sense for information_schema
• Regression in Find and replace
• TokuDB Tables Show Size as "unknown"
• Use a slider for Internal relations
• Ability to disable the navigationhiding Feature
• Restrict configuration NavigationTreeDbSeparator to strings
• Disable the tooltip in the navigation panel's filter box
• Copy results to clipboard
• Reactivate cut&paste possibility in print view
• Extraneous message after edit + grid-edit
• Table header is empty with browsing an empty table
• Allow changing parameter order of routines
• Remove no password warning
• Clarify the meaning of "Stand-in structure for view" in SQL export
• HTML line break shown after a MySQL connection error message
• CSV import skip row count after
• Fixed displaying of SQL query on table operations
• Display binary strings as text if they are valid UTF-8
• Display routine specific privileges
• Copy multiple tables to database
• Support Cloudflare Flexible SSL
• Handle empty TABLE_COMMENT
• Drop support for old Internet Explorer versions
• Use modals for displaying forms in db structure page
• Show MySQL error messages in user language
• Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP >= 5.6
• Show more used PHP extensions
• Report when version check and error reporting are disabled
• Fix PDF schema export
• Remove ForceSSL configuration directive
• Remove support for Mozilla Prism
• Remove PmaAbsoluteUri configuration directive
• Fix autoloading of phpseclib
• Fixed rendering of missing extension error
• Errors on Structure tab when user only has select access on certain columns
• Missing documentation for $cfg['Servers'][$i]['favorite'] and $cfg['NumFavoriteTables']
• Avoid displaying UPDATE query twice
• Fixed CSV import
• Fix SQL syntax highlighting in database search page
• Fix error when we can not generate random string
• Fixed PHP syntax error in templates
• Fixed processing of queries with escaped quotes
• Fixed exporting tables with fields DEFAULT and COMMENT
• Hide edit and delete buttons when the results are not related to a table
• Fixed parsing of field definition
• Fixed rendering of table stats
• Fixed problems with PHP on Windows on table structure
• Like search strings being escaped incorrectly
• Rename exported databases/tables doesn't seem to work
• Undefined index: controllink
• PHP Fatal error: Call to undefined function __()

What is new in version 4.6.1:

What is new in version 4.6.0:

• Disabled storage engines
• Allow setting routine wise privileges
• Hide Insert tab for non-updatable views
• UI for defining partitioning in create table window
• Support JSON data type
• Editing partitions in table Structure
• Tracking does not make sense for information_schema
• Regression in Find and replace
• TokuDB Tables Show Size as "unknown"
• Use a slider for Internal relations
• Ability to disable the navigationhiding Feature
• Restrict configuration NavigationTreeDbSeparator to strings
• Disable the tooltip in the navigation panel's filter box
• Copy results to clipboard
• Reactivate cut&paste possibility in print view
• Extraneous message after edit + grid-edit
• Table header is empty with browsing an empty table
• Allow changing parameter order of routines
• Remove no password warning
• Clarify the meaning of "Stand-in structure for view" in SQL export
• HTML line break shown after a MySQL connection error message
• CSV import skip row count after
• Fixed displaying of SQL query on table operations
• Display binary strings as text if they are valid UTF-8
• Display routine specific privileges
• Copy multiple tables to database
• Support Cloudflare Flexible SSL
• Handle empty TABLE_COMMENT
• Drop support for old Internet Explorer versions
• Use modals for displaying forms in db structure page
• Show MySQL error messages in user language
• Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP >= 5.6
• Show more used PHP extensions
• Report when version check and error reporting are disabled
• Fix PDF schema export
• Remove ForceSSL configuration directive
• Remove support for Mozilla Prism
• Remove PmaAbsoluteUri configuration directive
• Fix autoloading of phpseclib
• Fixed rendering of missing extension error
• Errors on Structure tab when user only has select access on certain columns
• Missing documentation for $cfg['Servers'][$i]['favorite'] and $cfg['NumFavoriteTables']
• Avoid displaying UPDATE query twice
• Fixed CSV import
• Fix SQL syntax highlighting in database search page
• Fix error when we can not generate random string
• Fixed PHP syntax error in templates
• Fixed processing of queries with escaped quotes
• Fixed exporting tables with fields DEFAULT and COMMENT
• Hide edit and delete buttons when the results are not related to a table
• Fixed parsing of field definition
• Fixed rendering of table stats
• Fixed problems with PHP on Windows on table structure
• Like search strings being escaped incorrectly
• Rename exported databases/tables doesn't seem to work
• Undefined index: controllink
• PHP Fatal error: Call to undefined function __()

What is new in version 4.5.5.1:

• Usability improvements for console
• Access to Add columns text-box and Go button when creating table
• Add lock tables, disable keys options
• Additional page locking
• Support MySQL 5.7 syntax for password change
• Display/edit index name
• Toggle autocomplete of table and column names
• Manage multiple variable in bookmarked query
• Show edit/delete also when there is calculated column
• Show databases as list instead of as dropdown when no database is selected
• Optional dark theme for the console
• PDF schema sort options
• Structure in PDF export
• Have ZeroConf create phpmyadmin DB if possible
• Warning before silent data conversion/truncation
• Support a default page in designer
• Allow copying mutiple rows
• No SQL query for loading data
• New data validation feature and datetime type
• Importing and exporting pMA meta-data
• Add grouping to stored procedures in the navigation tree
• Support IPv6 browser transformation
• Option groups for 'With selected' dropdown in database structure page
• Support CHECKSUM TABLE operation
• Support for Paramaters with raw SQL

What is new in version 4.5.4.1:

• Usability improvements for console
• Access to Add columns text-box and Go button when creating table
• Add lock tables, disable keys options
• Additional page locking
• Support MySQL 5.7 syntax for password change
• Display/edit index name
• Toggle autocomplete of table and column names
• Manage multiple variable in bookmarked query
• Show edit/delete also when there is calculated column
• Show databases as list instead of as dropdown when no database is selected
• Optional dark theme for the console
• PDF schema sort options
• Structure in PDF export
• Have ZeroConf create phpmyadmin DB if possible
• Warning before silent data conversion/truncation
• Support a default page in designer
• Allow copying mutiple rows
• No SQL query for loading data
• New data validation feature and datetime type
• Importing and exporting pMA meta-data
• Add grouping to stored procedures in the navigation tree
• Support IPv6 browser transformation
• Option groups for 'With selected' dropdown in database structure page
• Support CHECKSUM TABLE operation
• Support for Paramaters with raw SQL

What is new in version 4.5.2:

• Usability improvements for console
• Access to Add columns text-box and Go button when creating table
• Add lock tables, disable keys options
• Additional page locking
• Support MySQL 5.7 syntax for password change
• Display/edit index name
• Toggle autocomplete of table and column names
• Manage multiple variable in bookmarked query
• Show edit/delete also when there is calculated column
• Show databases as list instead of as dropdown when no database is selected
• Optional dark theme for the console
• PDF schema sort options
• Structure in PDF export
• Have ZeroConf create phpmyadmin DB if possible
• Warning before silent data conversion/truncation
• Support a default page in designer
• Allow copying mutiple rows
• No SQL query for loading data
• New data validation feature and datetime type
• Importing and exporting pMA meta-data
• Add grouping to stored procedures in the navigation tree
• Support IPv6 browser transformation
• Option groups for 'With selected' dropdown in database structure page
• Support CHECKSUM TABLE operation
• Support for Paramaters with raw SQL

What is new in version 4.5.0.2:

• Usability improvements for console
• Access to Add columns text-box and Go button when creating table
• Add lock tables, disable keys options
• Additional page locking
• Support MySQL 5.7 syntax for password change
• Display/edit index name
• Toggle autocomplete of table and column names
• Manage multiple variable in bookmarked query
• Show edit/delete also when there is calculated column
• Show databases as list instead of as dropdown when no database is selected
• Optional dark theme for the console
• PDF schema sort options
• Structure in PDF export
• Have ZeroConf create phpmyadmin DB if possible
• Warning before silent data conversion/truncation
• Support a default page in designer
• Allow copying mutiple rows
• No SQL query for loading data
• New data validation feature and datetime type
• Importing and exporting pMA meta-data
• Add grouping to stored procedures in the navigation tree
• Support IPv6 browser transformation
• Option groups for 'With selected' dropdown in database structure page
• Support CHECKSUM TABLE operation
• Support for Paramaters with raw SQL

What is new in version 4.4.8:

• Fixed bugs:
• Edit vs Change
• Don't scroll (to bottom) when editing multiple rows
• Misaligned Inline edit field
• Use of undefined constant PMA_DRIZZLE
• sprintf(): Too few arguments
• Limit column ordering in index edit dialog
• Incorrect ALTER TABLE statement generated
• Inconsistency in 'Ignore' checkbox in insert page
• Drop column action not asking to confirm
• Error on creating table
• Undefined index: Rows

What is new in version 4.4.6 / 3.5.8.2 / 2.11.11.3:

• Fixed bugs:
• Edit vs Change
• Don't scroll (to bottom) when editing multiple rows
• Misaligned Inline edit field
• Use of undefined constant PMA_DRIZZLE
• sprintf(): Too few arguments
• Limit column ordering in index edit dialog
• Incorrect ALTER TABLE statement generated
• Inconsistency in 'Ignore' checkbox in insert page
• Drop column action not asking to confirm
• Error on creating table
• Undefined index: Rows

What is new in version 4.3.10 / 3.5.8.2 / 2.11.11.3:

• Fixed:
• Changing $cfg['DefaultTabTable'] doesn't update link and title
• Undefined index menuswork
• Undefined index navwork
• Undefined index central_columnswork
• Server Status refresh not behaving as expected
• Null argument in array_multisort()
• Navigation panel should not hide icons based on 'TableNavigationLinksMode'
• Unsaved schema page exported as pdf.pdf
• Call to undefined method PMA_Schema_PDF::dieSchema()
• URL is non RFC-2396 compatible in get_scripts.js.php

What is new in version 4.3.0:

• Smart sorting for int keys
• Confirmation message when dropping user(s)
• Confirm dialog on accidentally leaving a page
• Allow clicking an approximate row count to get a correct one
• Support for editing binary fields in hexadecimal
• MariaDB 10+ multi-master replication support
• Allow saving query charts as images
• Use aliases in SQL export for tables and columns
• Export with table/column name changes
• Dynamic process list
• Drag and Drop SQL import
• Preview SQL instead of executing it
• Run SQL query: Allow rollback for InnoDB tables
• Zeroconf PMA tables support
• Regexp replace
• Avoid session timeout when user is active
• MySQL 5.7.5 compatibility
• Avoid session timeout when user is active
• Multiple-column foreign key relation
• Charts for data in <x-axis, series,="" value=""> format
• Range Search Capability
• Improvements for the table editor (index creation)
• PHP OpenSSL support for cookie encryption/decryption

What is new in version 4.2.9:

• Fixed bugs:
• ajax.js responseHandler: cannot read property of null
• sql.js: str is undefined
• Allow for direct selection of "0" on the "user overview" page
• Undefined index: pos
• tbl_change.js: insert as new row submit type on multiple selected records does Not set all AUTO_INCREMENTs to 0 value
• ajax.js responseHandler: another "cannot read property"
• tbl_structure.js "cannot read property"

What is new in version 4.2.5:

• Fixed bugs:
• shell_exec() has been disabled for security reasons
• Error while submitting empty query
• Fatal error: Class 'PMA_DatabaseInterface' not found
• Cookie based login for installations without mcrypt
• Incorrect result count when having clause is used
• mcrypt: remove the requirement (64-bit) and the related warning

What is new in version 4.2.2:

• Disable database expansion when enabled throws Error 500 when database name is clicked in navigation tree
• Table display of performance_schema DB structure
• Protect Binary Columns: many problems
• BLOB link transformation is broken
• Respect ['ShowCreateDb'] in the navi panel

What is new in version 4.2.0:

• Added the ability to save and load queries in Query By Example.
• Navigation tabs are now fixed and don't scroll off screen.
• Easily add a function to all rows when inserting several rows at once.
• Added a favorite tables feature for quick access to often-used tables.
• Quick filter displayed rows.

What is new in version 4.1.12:

• Bugs:
• Datepicker won't open
• Missing value error while executing SQL query
• TCPDF library is now optional dependency
• Cannot find the import plugins which start with uppercase 'I'

What is new in version 4.1.0:

• Make warning about existing config directory clearer
• Allow specifying controlport
• DBI functions in database interface libraries renamed to be compliant with PEAR standards
• Creating a view from an empty set of results
• Improved layout on db and table operations pages
• Added support for AES_ENCRYPT for blob fields
• Clarify option text for icon/text settings
• Upgraded CodeMirror to 3.x series
• Improved query profiler
• Better suggestion for database name
• Support relations with ndbcluster
• Proper escaping of JSON export
• Optional ReCAPTCHA support
• Improvements to the table browsing navigation bar
• Improvements to Relation View interface
• Use fractional seconds in time, datetime, and timestamp
• Allow cross-database relations

What is new in version 4.0.9:

• Fixed bugs:
• Can't edit updatable view when searching
• Missing refresh by deleting databases
• Drizzle server charset notice
• Filtering database names includes empty groupings
• Does not display or manipulate bit(64) fields appropriately
• Unneeded navi panel refresh
• SSL redirects to port 80
• DROP DATABASE displays wrong database name
• Running delete query asks for confirmation but says it was already executed
• Accessibility: Images without Alt nor title attribute

What is new in version 4.0.8:

• Fixed bugs:
• Default table tab is ignored
• Server/library difference warning: setting is ignored
• Table tree group strategy
• ALTER TABLE ORDER BY and InnoDB
• Tracking report: cannot delete a statement
• Drizzle navigation doesn't expand
• GIS column editor: point not displayed
• Drizzle tables in navigation are shown as views
• NUL symbols added to the end of database dump file
• More disappears in table Structure
• Multi-row edit doesn't clear values when checking NULL

What is new in version 4.0.4.1:

• Fixed:
• Global variables scope injection vulnerability.

What is new in version 4.0.2:

• Fixed:
• Structure not refreshed after column drop
• View is not updatable
• PropertiesIconic not honored
• Databases to choose for specific privileges show up escaped
• Export database with empty table as a php array, does not produce valid PHP
• Query profiler chart not loading from SQL Query page
• Missing CSV import option "Do not abort on INSERT error"
• Missing Operations>Table options>AUTO_INCREMENT
• Missing CREATE DATABASE statement when exporting at database level
• Show warning when CSV file does not contain data for all columns
• Missing Sql Query after modify structure
• Server export problems
• CountTables directive is deprecated

What is new in version 4.0.0:

• Version 4.0 contains many bug fixes and smaller new features; moreover, the documentation has a new look and contains an index.

What is new in version 3.5.8.1:

• Security fixes:
• Remote code execution (preg_replace).
• Locally Saved SQL Dump File Multiple File Extension Remote Code Execution.

What is new in version 4.0.0-alpha1:

• The HTML frames are gone and the navigation panel now presents a tree.

What is new in version 3.5.4:

• Fixed:
• uuid_short() is a no-arguments function
• Routine parameter headers not valid for "function"
• Various search operators not working as expected
• Invalid select query generated for tables with ENUM fields
• Incorrect imagejpeg Syntax Breaks Image Transformation
• Editing SQL not possible when no records found
• Display chart and number of rows to plot
• Wrong redirect url caused cookies error with ForceSSL

What is new in version 3.5.0:

• Browse-mode improvements
• Grid editing
• Remember recent tables
• Remember last sort order by table
• Flexible column width
• Reorder columns
• More compact navigation bar
• AJAXification of many operations
• Reorganised server status page, with server monitoring
• Improved support for stored routines, events and triggers
• openGIS support
• Zoom-search in table search
• Drizzle support

What is new in version 3.5.0-rc2:

• Browse-mode improvements
• AJAXification of many operations
• Reorganised server status page, with server monitoring
• Improved support for stored routines, events and triggers
• openGIS support
• Zoom-search in table search
• Drizzle support
• Improved ENUM/SET editor

What is new in version 3.4.10.1:

• phpMyAdmin 3.4.10.1, a minor security release.

What is new in version 3.5.0-beta1:

• Browse-mode improvements
• Grid editing
• Remember recent tables
• Remember last sort order by table
• Flexible column width
• Reorder columns
• More compact navigation bar
• AJAXification of many operations
• Reorganised server status page, with server monitoring
• Improved support for stored routines, events and triggers
• OpenGIS support
• Zoom-search in table search
• Drizzle support
• Improved ENUM/SET editor

What is new in version 3.5.0-alpha1:

• Browse-mode improvements
• Grid editing
• Remember recent tables
• Remember last sort order by table
• Flexible column width
• Reorder columns
• More compact navigation bar
• AJAXification of many operations
• Reorganised server status page, with server monitoring
• Improved support for stored routines, events and triggers
• openGIS support
• Zoom-search in table search
• Drizzle support
• Improved ENUM/SET editor

What is new in version 3.4.8:

• phpMyAdmin 3.4.8 is a bugfix release with minor security fixes.

What is new in version 3.4.8-rc1:

• Bugfix release with minor security corrections.

What is new in version 3.4.7:

• Bug #3418610 [interface] Links in navigation when $cfg['MainPageIconic'] = false
• Bug #3418849 [interface] Inline edit shows dropdowns even after closing
• Bug [view] View renaming did not work
• Bug [navi] Wrong icon for view (MySQL 5.5)
• Bug #3420229 [doc] Missing documentation section
• Bug #3423725 [pdf] Broken PDF file when exporting database to PDF
• Bug [core] Allow to set language in URL
• Bug #3425184 [doc] Fix links to PHP documentation
• Bug #3426031 [export] Export to bzip2 is not working

What is new in version 3.4.4 / 3.3.10.4:

• phpMyAdmin 3.4.4 is a bugfix and security release, and phpMyAdmin 3.3.10.4 is a security release.

What is new in version 3.4.3:

• phpMyAdmin 3.4.3, a bugfix release.

What is new in version 3.4.3-rc1:

• phpMyAdmin 3.4.3-rc1 is a bugfix release.

What is new in version 3.4.2:

• phpMyAdmin 3.4.2, a bugfix release.

What is new in version 3.4.1-rc1:

• The first release candidate for phpMyAdmin 3.4.1, a bugfix release.

What is new in version 3.4.0:

• User preferences
• Relation schema export to multiple formats
• ENUM/SET editor
• Simplified interface for export/import
• AJAXification of some parts
• Charts
• Visual query builder

What is new in version 3.4.0-rc2:

• User preferences.
• Relation schema export to multiple formats.
• ENUM/SET editor.
• Simplified interface for export/import.
• AJAXification of some parts.
• Charts.
• Visual query builder.

What is new in version 3.4.0-beta2:

• User preferences
• Relation schema export to multiple formats
• ENUM/SET editor
• Simplified interface for export/import
• AJAXification of some parts
• Charts
• Visual query builder

What is new in version 3.3.9:

• phpMyAdmin 3.3.9, a bugfix version.

What is new in version 3.4.0-beta1:

• User preferences.
• Relation schema export to multiple formats.
• ENUM/SET editor.
• Simplified interface for export/import.
• AJAXification of some parts.
• Charts.
• Visual query builder.

What is new in version 3.4.0-alpha2:

• User preferences.
• Relation schema export to multiple formats.
• ENUM/SET editor.
• Simplified interface for export/import.
• AJAXification of some parts.
• Charts.
• Visual query builder.

What is new in version 3.4.0-alpha1 / 3.3.8 / 2.11.11:

• User preferences
• Relation schema export to multiple formats
• ENUM/SET editor
• Simplified interface for export/import
• AJAXification of some parts
• Charts
• Visual query builder

What is new in version 3.3.8:

• phpMyAdmin 3.3.8 which is a bugfix version.

What is new in version 3.3.8-rc1 / 2.11.11:

• The first release candidate for phpMyAdmin 3.3.8 which is a bugfix version.

What is new in version 3.3.7 / 2.11.11:

• phpMyAdmin 3.3.7 and 2.11.11 are bugfix versions.

What is new in version 3.3.6:

• phpMyAdmin 3.3.6, a bugfix release.

What is new in version 3.3.6-rc1:

• phpMyAdmin 3.3.6, a bugfix release.

What is new in version 3.3.5:

• phpMyAdmin 3.3.5, a bugfix release.

What is new in version 3.3.5-rc1:

• phpMyAdmin 3.3.5, a bugfix release.

What is new in version 3.3.3:

• A bugfix release.

What is new in version 3.1.2-rc1:

• Bug fixes:
• [display] Can't NULL a column with relation defined
• [SQL] Small improvements in generated SQL (partial fix)
• [export] YAML export improvement
• [lang] Dutch update
• [cleanup] ereg*() deprecated in PHP 5.3
• [properties] Edit fields: losing auto-increment setting
• [changelog] changelog.php linkifies one link wrong
• [properties] Various problems with table structure
• [display] BIT field contents disappear when edited
• [lang] Czech update
• [operations] Table operations adds "row_format"
• [export] Commas for CSV Excel 2008 for Mac
• [core] ForceSSL and http auth_type
• [display] Deleting rows displays tbl structure, not contents
• [core] PHP 5.2+ warning does not work
• [privileges] Escaping special characters

Requirements:

• PHP 5.2.0+
• MySQL 5.0 or newer
• GD2 support in PHP
• mcrypt extension
• PHP zip extension
• mbstring and ctype extensions