phpMyAdmin Changelog

What's new in phpMyAdmin 5.2.1

Feb 8, 2023
  • Some highlights include:
  • issue #17506 Fix error when configuring 2FA without XMLWriter or Imagick
  • issue #17519 Fix Export pages not working in certain conditions
  • issue #17121 Fix password_hash function incorrectly adding single quotes to password before hashing
  • issue #17736 Add utf8mb3 as an alias of utf8 on the charset description page
  • issue #17248 Support the UUID data type for MariaDB >= 10.7
  • issue #16042 Fixes malformed downloads when using gzip compression type and FireFox browser
  • Add `spellcheck="false"` to all password fields and some text fields to avoid spell-jacking data leaks
  • Fixes for JavaScript errors when using Designer
  • Fixes for PHP 8.2 compatibility

New in phpMyAdmin 5.2.0 (May 11, 2022)

  • Removed support for Microsoft Internet Explorer
  • Requires PHP 7.2 or newer
  • Requires the openssl PHP extension
  • Improved handling of system CA bundle and cacert.pem, falling back to Mozilla CA if needed
  • Replace "master/slave" terms with "primary/replica"
  • Add "NOT LIKE %...%" operator to Table search
  • Add support for the Mroonga engine
  • Add support for account locking
  • Several fixes and improvements to the SQL parser library

New in phpMyAdmin 5.1.3 (Feb 11, 2022)

  • The security issue, reported by Rafael Pedrero, could allow users to cause an error that would reveal the path on disk where phpMyAdmin is running from.
  • We believe this requires the server to be running with display_errors on, which is not the recommended setting for a production environment.
  • The main bug fix relates to the navigation pane, when browsing a database with more tables than the configured limit, the pagination would show the list of databases instead of tables.
  • There are also several other bug fixes, including
  • Fix MariaDB has no support for system variable "disabled_storage_engines"
  • Fixed importing browser settings question box after login when having no pmadb
  • Fixed repeating headers are not working
  • and several more.

New in phpMyAdmin 5.1.2 (Jan 22, 2022)

  • Security fixes:
  • Fix for a user potentially being able to disable their two factor authentication (PMASA-2022-1)
  • Add a new configuration directive $cfg['URLQueryEncryption'] to allow encrypting sensitive information in the URL to prevent disclosure. Thanks to Rich Grimes for suggesting this improvement
  • Add a new configuration directive $cfg['Servers'][$i]['hide_connection_errors'] to allow hiding the full error message when a log on attempt fails, which can leak hostnames or IP addresses of the target database server. Thanks to Dr. Shuzhe Yang, Manager Security Governance at GLS IT Services for suggesting this improvement
  • Fixes for XSS and HTML injection attack in the graphical setup page (PMASA-2022-2)
  • Bug fixes:
  • Revert a changed to $cfg['CharTextareaRows'] allow values less than 7
  • Fix encoding of enum and set values on edit value
  • Fixed possible "Undefined index: clause_is_unique" error
  • Fixed some situations where a user is logged out when working with more than one server
  • Fixed a problem with assigning privileges to a user using the multiselect list when the database name has an underscore
  • Enable cookie parameter "SameSite" when the PHP version is 7.3 or newer
  • Correctly handle the removal of "innodb_file_format" in MariaDB and MySQL

New in phpMyAdmin 5.1.1 (Jun 4, 2021)

  • Fixes for several PHP errors
  • Fixes for "$cfg['DefaultTabDatabase']" and other related configuration directives not working properly
  • Fix Yaml export to quote strings even when they are numeric
  • Fix TCPDF open_basedir issue due to internal guessing code from TCPDF
  • Fix for quick search not working when using more than one configured server
  • Fix datetime decimals displayed (.00000) after edit
  • Fix new lines in text fields are doubled
  • Fixed URL generation by removing un-needed & escaping for & char
  • Improvements for working with PHP 8.1
  • Improved handling of adding a new user with the Percona database server

New in phpMyAdmin 5.1.0 (Feb 24, 2021)

  • Іmрrоvе vіrtuаlіtу drорdоwn fоr МаrіаDВ > 10.1
  • Аddеd аn орtіоn tо реrfоrm АLТЕR ОNLІNЕ (АLGОRІТНМ=ІNРLАСЕ) whеn еdіtіng а tаblе ѕtruсturе
  • Аddеd ір2lоng trаnѕfоrmаtіоn
  • Іmрrоvеmеntѕ tо lіnkіng tо МуЅQL аnd МаrіаDВ dосumеntаtіоn
  • Аdd „Рrеvіеw ЅQL“ орtіоn оn Іndех dіаlоg bох whеn сrеаtіng а nеw tаblе
  • Аdd а nеw vеndоr соnѕtаnt „САСНЕ_DІR“ thаt dеfаultѕ tо „lіbrаrіеѕ/сасhе/“ аnd ѕtоrе rоutіng сасhе іntо thіѕ fоldеr
  • Аdd $сfg[‘СарtсhаЅіtеVеrіfуURL’] fоr Gооglе RеСарtсhа ѕіtеVеrіfуUrl
  • Аdd thе раѕѕwоrd_hаѕh РНР funсtіоn аѕ аn орtіоn whеn іnѕеrtіng dаtа
  • Іmрrоvеmеntѕ tо еdіtіng аnd dіѕрlауіng соlumnѕ оf thе ЈЅОN dаtа tуре.
  • Аddеd ѕuрроrt fоr „ЅаmеЅіtе=Ѕtrісt“ оn сооkіеѕ uѕіng соnfіgurаtіоn „$сfg[‘СооkіеЅаmеЅіtе’]“
  • Fіхеd АWЅ RDЅ ІАМ аuthеntісаtіоn dоеѕn’t wоrk bесаuѕе рmа_раѕѕwоrd іѕ trunсаtеd
  • Аdd соnfіg раrаmеtеrѕ tо ѕuрроrt thіrd-раrtу RеСарtсhа v2 соmраtіblе АРІѕ lіkе hСарtсhа
  • Аdd $сfg[‘МуѕqlЅѕlWаrnіngЅаfеНоѕtѕ’] tо ѕеt thе rеd tехt blасk whеn ѕѕl іѕ nоt uѕеd оn а рrіvаtе nеtwоrk
  • Ехроrt blоbѕ аѕ hех оn ЈЅОN ехроrt
  • Fіх lеаdіng ѕрасе nоt ѕhоwn іn а СНАR соlumn whеn brоwѕіng а tаblе
  • Аddеd а rеnаmе Вuttоn tо uѕе RЕNАМЕ ІNDЕХ ѕуntах оf МуЅQL 5.7 (аnd МаrіаDВ >= 10.5.2)
  • Fіхеd mіѕѕіng орtіоn tо еntеr ТАВLЕ ѕресіfіс реrmіѕѕіоnѕ whеn thе dаtаbаѕе nаmе соntаіnѕ аn „_“ (undеrѕсоrе)
  • Fіхеd а РНР nоtісе „Тrуіng tо ассеѕѕ аrrау оffѕеt оn vаluе оf tуре null“ оn Dеѕіgnеr РDF ехроrt
  • Fіх fоr ѕеvеrаl РНР 8 wаrnіngѕ оr еrrоrѕ, gіvіng thіѕ rеlеаѕе full соmраtіbіlіtу wіth РНР 8

New in phpMyAdmin 5.1 RC 2 (Feb 17, 2021)

  • There are many new features and bug fixes; a few highlights include:
  • Improve virtuality dropdown for MariaDB > 10.1
  • Added an option to perform ALTER ONLINE (ALGORITHM=INPLACE) when editing a table structure
  • Added ip2long transformation
  • Improvements to linking to MySQL and MariaDB documentation
  • Add "Preview SQL" option on Index dialog box when creating a new table
  • Add a new vendor constant "CACHE_DIR" that defaults to "libraries/cache/" and store routing cache into this folder
  • Add $cfg['CaptchaSiteVerifyURL'] for Google ReCaptcha siteVerifyUrl
  • Add the password_hash PHP function as an option when inserting data
  • Improvements to editing and displaying columns of the JSON data type.
  • Added support for "SameSite=Strict" on cookies using configuration "$cfg['CookieSameSite']"
  • Fixed AWS RDS IAM authentication doesn't work because pma_password is truncated
  • Add config parameters to support third-party ReCaptcha v2 compatible APIs like hCaptcha
  • Add $cfg['MysqlSslWarningSafeHosts'] to set the red text black when ssl is not used on a private network
  • Export blobs as hex on JSON export
  • Fix leading space not shown in a CHAR column when browsing a table
  • Added a rename Button to use RENAME INDEX syntax of MySQL 5.7 (and MariaDB >= 10.5.2)
  • Fixed missing option to enter TABLE specific permissions when the database name contains an "_" (underscore)
  • Fixed a PHP notice "Trying to access array offset on value of type null" on Designer PDF export
  • Fix for several PHP 8 warnings or errors, giving this release full compatibility with PHP 8

New in phpMyAdmin 5.0.4 (Oct 15, 2020)

  • Fixes this version:
  • Two factor authentication was broken
  • Incompatibilities with older PHP versions.

New in phpMyAdmin 5.0.3 (Oct 10, 2020)

  • First the security fixes:
  • PMASA-2020-5 XSS vulnerability with transformation feature
  • PMASA-2020-6 SQL injection vulnerability with the search feature
  • Next a few of the key bugfixes included with this release:
  • Fix an error message about htmlspecialchars() when attempting to export XML
  • Support double tapping to edit on mobile
  • Fix the error message "Use of undefined constant MYSQLI_TYPE_JSON" when using mysqlnd
  • Fix fatal JS error on index creation after using Enter key to submit the form
  • Fix "axis-order" to swap latitude and longitude on MySQL 8.1 or newer
  • Fix an error when overwriting an existing query bookmark
  • Fix some warnings that appear with PHP 8
  • Fix alter user privileges query when editing an account with MySQL 8.0.11 and newer
  • Fix issues regarding TIMESTAMP columns with default CURRENT_TIMESTAMP in MySQL 8.0.13 and newer
  • Fix a message that "Warning: error_reporting() has been disabled for security reasons" on php 7.x

New in phpMyAdmin 5.0.1 (Jan 8, 2020)

  • The two most notable fixes:
  • Issue #15724 regarding two-factor authentication
  • PMASA-2020-1 which is an SQL injection vulnerability in the user accounts page

New in phpMyAdmin 5.0.0 (Dec 27, 2019)

  • With this release, we are removing support of old PHP versions (5.5, 5.6, 7.0, and HHVM). These versions are outdated and are no longer supported by the PHP team.
  • Version 5.0 includes many coding improvements that modernize the interface. Many of these changes are transparent to users, but make the code easier to maintain.
  • Much of this refactoring work is completed by our contract developer, Maurício Meneghini Fauth. We always consider applications for new (paid) contract developers.
  • Some of the changes and new features include:
  • Enable columns names by default for CSV exports
  • Add Metro theme
  • Automatically add the index when creating an auto increment column
  • Improvements to exporting views
  • Prompt the user for confirmation before running an UPDATE query with no WHERE clause
  • Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
  • Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
  • Use charset 'windows-1252' when export format is MS Excel

New in phpMyAdmin 4.9.3 (Dec 27, 2019)

  • Several PHP notices and warnings including "Undefined index table_create_time,"
  • a notice about error_reporting() being disabled for security reasons, and several Undefined Index errors.
  • Support CloudFront-Forwarded-Protheader for Amazon CloudFront proxy
  • Early compatibility with development versions of PHP 8
  • Fix replication actions (start, stop, etc)

New in phpMyAdmin 4.9.2 (Nov 22, 2019)

  • Fixes for the "Failed to set session cookie" error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2
  • Fix for Advisor with MySQL 8.0.3 and newer
  • Fix PHP deprecation errors
  • Fix a situation where exporting users after a delete query could remove users
  • Fix incorrect "You do not have privileges to manipulate with the users!" warning
  • Fix copying a database's privileges and several other problems moving columns with MariaDB
  • Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export

New in phpMyAdmin 4.9.1 (Sep 21, 2019)

  • Editing columns with CURRENT_TIMESTAMP for MySQL versions 8.0.13 and newer
  • Compatibility issues with PHP 8
  • Export of GIS visualization
  • Enhanced descriptions for several collation types
  • Creating a user with a single quote in the password string
  • Unexpected quotes during import and export on text fields
  • Improvements to adding new tables to Designer
  • Fix an issue where an authenticated user could trigger heavy traffic between the database server and web server
  • Fix a weakness where an attacker, under certain conditions, working at the same time as an administrator is using the setup script, could delete a server from the setup script

New in phpMyAdmin 4.9.0 (Jun 5, 2019)

  • This release fixes two security vulnerabilities:
  • PMASA-2019-3 is an SQL injection flaw in the Designer feature
  • PMASA-2019-4 is a CSRF attack that's possible through the 'cookie' login form
  • Upgrading is highly recommended for all users. Using the 'http' auth_type instead of 'cookie' can mitigate the CSRF attack.
  • The solution for the CSRF attack does remove the former functionality to log in directly through URL parameters (as mentioned in FAQ 4.8, such as https//example.com/phpmyadmin/?pma_username=root&password=foo). Such behavior was discouraged and is now removed. Other query parameters work as expected; only pma_username and pma_password have been removed.
  • This release also includes fixes for many bugs, including:
  • Several issues with SYSTEM VERSIONING tables
  • Fixed json encode error in export
  • Fixed JavaScript events not activating on input (sql bookmark issue)
  • Show Designer combo boxes when adding a constraint
  • Fix edit view
  • Fixed invalid default value for bit field
  • Fix several errors relating to GIS data types
  • Fixed javascript error PMA_messages is not defined
  • Fixed import XML data with leading zeros
  • Fixed php notice, added support for 'DELETE HISTORY' table privilege (MariaDB >= 10.3.4)
  • Fixed MySQL 8.0.0 issues with GIS display
  • Fixed "Server charset" in "Database server" tab showing wrong information
  • Fixed can not copy user on Percona Server 5.7
  • Updated sql-parser to version 4.3.2, which fixes several parsing and linting problems

New in phpMyAdmin 4.8.5 (Apr 19, 2019)

  • The security fixes involve:
  • Arbitrary file read vulnerability (https://www.phpmyadmin.net/security/PMASA-2019-1)
  • SQL injection in the Designer interface (https://www.phpmyadmin.net/security/PMASA-2019-2)
  • The arbitrary file read vulnerability could also be exploited to delete arbitrary files on the server. This attack requires that phpMyAdmin be run with the $cfg['AllowArbitraryServer'] directive set to true, which is not the default. An attacker must run a malicious server process that will masquerade as a MySQL server. This exploit has been found and fixed recently in several other related projects and appears to be caused by a bug in PHP (https://bugs.php.net/bug.php?id=77496).
  • In addition to the security fixes, this release also includes these bug fixes and more as part of our regular release cycle:
  • Export to SQL format not available
  • QR code not shown when adding two-factor authentication to a user account
  • Issue with adding a new user in MySQL 8.0.11 and newer
  • Frozen interface relating to Text_Plain_Sql plugin
  • Table level Operations tab was missing

New in phpMyAdmin 4.8.3 (Aug 22, 2018)

  • An error where a database is named 0
  • Fix for NULL as default not being shown
  • Fix for recent tables list
  • Fix for slow performance with table filtering
  • Two-factor authentication (2FA) fails if the GD PHP library is missing
  • Event scheduler toggle does not work
  • ERR_BLOCKED_BY_XSS_AUDITOR error when exporting a table
  • PHP 7.3 warning: "continue" in "switch" is equal to "break"

New in phpMyAdmin 4.8.2 (Jun 21, 2018)

  • Among other bug fixes, this contains an important security update and it is highly recommended that all users upgrade immediately. The urgent vulnerability allows an authenticated attacker to exploit a phpMyAdmin feature to show and potentially execute files on the server. PHP open_basedir restrictions mitigate the effect of this flaw. For further details, see the PMASA announcement.
  • A second flaw was also fixed allowing an attacker to use a specially crafted database name to trick a user in to executing a cross-site scripting (XSS) attack in the Designer feature.
  • In addition to the security fixes, this release also includes these bug fixes as part of our regular release cycle:
  • WHERE 0 clause causes a fatal error
  • Fix missing "INDEX" icon

New in phpMyAdmin 4.8.1 (May 25, 2018)

  • Future version compatible with PHP 5.5 to 7.2 and MySQL 5.5 and newer.

New in phpMyAdmin 4.8.0.1 (Apr 19, 2018)

  • This version fixes a security flaw found in version 4.8.0 where an attacker can manipulate
  • a user in to following a specially-crafted link, allowing the attacker to execute arbitrary
  • SQL commands on the server. For more information, please see

New in phpMyAdmin 4.8.0 (Apr 10, 2018)

  • Allow the removal of individual segments from pie charts
  • Improved database search to allow matching the exact phrase
  • PhpMyAdmin no longer requires using the PHP eval() function
  • The mbstring dependency is now optional
  • Authentication logging using $cfg['AuthLog']
  • Add support for Google's Invisible Captcha
  • Improved handling of reCAPTCHA
  • Fixes to the JavaScript editor for TIME values
  • Improved the editor for the JSON data type
  • Add "Format" button to the edit view form
  • Implement mobile interface
  • There are now configuration directives to set defaults for Transformation options
  • Allow Designer to show tables from other databases
  • Add support for authentication using U2F and 2FA
  • Designer: fix broken "Add tables from other database"
  • Fix double escaping of ENUM dropdown
  • Restore SQL query after session expires
  • Query builder: Fix for new column not being added
  • Fix for blank login page
  • Changes to the handling of arg_separator for AJAX requests; see issue #13940
  • Structure tab: fix silent failure to create new indexes
  • Fix improperly escaped HTML code on the database structure page
  • Fix JavaScript errors when using Internet Explorer (in particular when editing rows)
  • Fix for broken error report
  • Fix failed import
  • Fix for "Cannot read property sql_query of undefined" errors

New in phpMyAdmin 4.8.0 RC 1 (Mar 27, 2018)

  • Welcome to the release candidate version of the upcoming 4.8.0 release. This is likely to be the final testing release before 4.8.0 is officially released.
  • Notable changes since 4.8.0-alpha1:
  • Designer: fix broken "Add tables from other database"
  • Fix double escaping of ENUM dropdown
  • Restore SQL query after session expires
  • Query builder: Fix for new column not being added
  • Fix for blank login page
  • Changes to the handling of arg_separator for AJAX requests; see issue #13940
  • Structure tab: fix silent failure to create new indexes
  • Fix improperly escaped HTML code on the database structure page
  • ix JavaScript errors when using Internet Explorer (in particular when editing rows)
  • Fix for broken error report
  • Fix failed import
  • Fix for "Cannot read property sql_query of undefined" errors
  • The remaining notes are for changes from the 4.7.x branch to 4.8.0 and also applied to 4.8.0-alpha1.

New in phpMyAdmin 4.7.8 (Feb 20, 2018)

  • The security fix relates to a self-XSS vulnerability in the central columns feature
  • that is reported as PMASA-2018-1 .
  • Notable changes since 4.7.7:
  • Fixed error handling with PHP 7.2
  • Fixed resetting default setting values
  • Fixed fallback value for collation connection

New in phpMyAdmin 4.7.7 (Dec 26, 2017)

  • Fixed displaying of formatted numeric values for some locales
  • Fixed PHP error when browsing certain results

New in phpMyAdmin 4.7.6 (Dec 1, 2017)

  • Notable changes since 4.7.5:
  • Fixed 'check all' interaction with filtering
  • Add SJIS-win to default list of allowed charsets
  • Improve detection that MySQL server needs SSL connection
  • Support JSON datatype on MariaDB 10.2.7 and newer
  • Fixed constructing ALTER query with AFTER
  • Fixed changing password on MariaDB cluster

New in phpMyAdmin 4.7.5 (Oct 23, 2017)

  • Fixed JavaScript error in server monitor
  • Reload JavaScript translations when changing language
  • Fixed error when browsing non-SELECT results
  • Fixed export of table with VIRTUAL columns
  • Fixed incorrectly selecting the next row when selecting multiple rows
  • Fixes for input transformations

New in phpMyAdmin 4.7.4 (Aug 25, 2017)

  • Notable changes since 4.7.3:
  • Fixed the per-server theme feature
  • Fixed several compatibility issues with PHP 7.2
  • Fixed copy results to clipboard
  • Improved error handling on corrupted tables

New in phpMyAdmin 4.7.3 (Jul 21, 2017)

  • Notable changes since 4.7.2:
  • Fixed creating relations
  • Fixed export without back quotes
  • Improved handling of uploaded files with open_basedir
  • Fixed usage of some browser transformations
  • Automatically connect using SSL when server is configured for such

New in phpMyAdmin 4.7.2 (Jun 30, 2017)

  • Current version compatible with PHP 5.5 to 7.1 and MySQL 5.5 and newer.

New in phpMyAdmin 4.7.1 (May 29, 2017)

  • Notable changes since 4.7.0:
  • Fibroken links in setup script
  • Fipagination while browsing results
  • Do not include developer dependencies when creating the release
  • Fihandling of errors in AJArequests
  • FiPHP error on password change
  • Firefresh of long queries
  • Improved handling of logout with disabled LoginCookieDeleteAll
  • Add support for MySQL 8.0 collations
  • Fixed detection of Amazon RDS
  • Fifor grid editing repeating action after error

New in phpMyAdmin 4.7.0 (Mar 29, 2017)

  • Notable changes since 4.6.6:
  • Fix an issue where $cfg['Servers'][$i]['AllowNoPassword'] is ignored (PMASA-2017-8)
  • Fix JavaScript errors when using Designer
  • Show all databases in dropdown selector, including the current one
  • Better defaults when creating a multi-field foreign key
  • Improved support for TokuDB
  • Improved handling of LoginCookieValidity, this should improve certain cases where users were getting logged out prematurely
  • Fix an error that could occur when copying a database (related to pmadb/Configuration Storage metadata)
  • Fixed OpenDocument exports
  • Fixed alignment of NULL values
  • Removed error message about client and server version mismatch
  • Compatibility fixes when running under HHVM 3.18
  • Fix the version check when curl is incorrectly configured
  • Change the default export setting for Excel files; now the default is to include column names in the first row. This is always configurable with $cfg['Export']['excel_columns']
  • Log failed authentication attempts to syslog (useful for parsing by fail2ban, for example)
  • Add filtering for the database list
  • Add table filtering to the database 'Structure' tab
  • Add support for exporting user settings as a config.inc.php snippet
  • Add option to delete settings from browser storage
  • Changes to the JSON import and export format to better follow the JSON specification, however this breaks
  • compatibility with older versions. See https://docs.phpmyadmin.net/en/latest/import_export.html#json
  • Support for IPv6 proxies
  • Allow more connection parameters for the controluser connection
  • Rename 'Relations' to 'Relationships' in many places as it's a more correct term
  • More documentation for export configuration options
  • Remove support for Swekey authentication
  • Remove support for old, unsupported versions of Microsoft Internet Explorer
  • Removed $cfg['ThemePath']
  • Starting with this version, phpMyAdmin uses Composer to manage PHP library dependencies while under development.
  • Users downloading the official source distribution will not notice a difference, however users of the git repository
  • should refer to https://docs.phpmyadmin.net/en/latest/setup.html#installing-from-git for details.
  • Also beginning with this version, we've made some changes to the files available for download. There are now three
  • different packages available: `all-langauges` and `english` are the same downloads we've offered for some time, the former
  • featuring all languages for which we have a reasonable amount of translations and the latter being a smaller English-only
  • download. We have added a `source` download, which includes the unit test suite, Gettext po files, documentation source, and
  • JavaScript source files; these are omitted from the other packages as most users have no need for them. We have also reduced
  • the number of compression formats available due to low utilization; for each package we have .tar.gz, .tar.xz, and .zip formats
  • available.
  • There are many more improvements; please refer to the ChangeLog for full details.

New in phpMyAdmin 4.7.0 RC 1 (Mar 9, 2017)

  • Fix JavaScript errors when using Designer
  • Show all databases in dropdown selector, including the current one
  • Better defaults when creating a multi-field foreign key
  • Improved support for TokuDB
  • Improved handling of LoginCookieValidity, this should improve certain cases where users were getting logged out prematurely
  • Fix an error that could occur when copying a database (related to pmadb/Configuration Storage metadata)
  • Fixed OpenDocument exports
  • Fixed alignment of NULL values
  • Removed error message about client and server version mismatch
  • Compatibility fixes when running under HHVM 3.18
  • Fix the version check when curl is incorrectly configured
  • Change the default export setting for Excel files; now the default is to include column names in the first row. This is always configurable with $cfg['Export']['excel_columns']

New in phpMyAdmin 4.7.0 Beta 1 (Jan 26, 2017)

  • Highlights:
  • Log failed authentication attempts to syslog (useful for parsing by fail2ban, for example)
  • Add filtering for the database list
  • Add table filtering to the database 'Structure' tab
  • Add support for exporting user settings as a config.inc.php snippet
  • Add option to delete settings from browser storage
  • Changes to the JSON import and export format to better follow the JSON specification, however this breaks
  • compatibilty with older versions. See https://docs.phpmyadmin.net/en/latest/import_export.html#json
  • Support for IPv6 proxies
  • Allow more connection parameters for the controluser connection
  • Rename 'Relations' to 'Relationships' in many places as it's a more correct term
  • More documentation for export configuration options
  • Remove support for Swekey authentication
  • Remove support for old, unsupported versions of Microsoft Internet Explorer
  • Removed $cfg['ThemePath']

New in phpMyAdmin 4.6.6 (Jan 24, 2017)

  • There have been changes in the behavior of previous version:
  • Changed the suggested text in the query window for delete queries to avoid accidental data loss
  • Re-introduce a page which shows the output of phpinfo()
  • Aside from the changes and security improvements, many bugs have been fixed including:
  • Parsing of SQL queries with the BINARY function
  • Syntax error when adding or changing TIMESTAMP columns with default value as NULL
  • Broken "Edit" and "Export" links in the Routines tab
  • Creating a new user on older MariaDB servers
  • Format button in the SQL tab broken
  • Fixes for PHP 7.1
  • Problems with MySQL servers running with `lower_case_names=2`
  • Fixes for several PHP notices/warnings being shown

New in phpMyAdmin 4.6.5.2 (Dec 6, 2016)

  • A patch-level release which fixes an issue with exporting certain character sequences including a backslash (),
  • such as rn..
  • Because this issue [#12765](https://github.com/phpmyadmin/phpmyadmin/issues/12765) affects export functionality, we do recommend updating when possible.

New in phpMyAdmin 4.6.5.1 (Nov 26, 2016)

  • Patch-level release fixing two small issues:
  • an issue affecting a small number of users using $cfg['Servers'][$i]['hide_db'] or $cfg['Servers'][$i]['only_db'].
  • an issue affecting the create table dialog where the partition selection tool was overzealous and made it difficult to create a new table.
  • There are also minor improvements to the Czech language file.

New in phpMyAdmin 4.6.5 (Nov 25, 2016)

  • Aside from the security improvements, many bugs have been fixed in version 4.6.5 including:
  • Fix for expanding in navigation pane
  • Reintroduced a simplified version of PmaAbsoluteUri directive (needed with reverse proxies)
  • Fix editing of ENUM/SET/DECIMAL field structures
  • Improvements to the parser

New in phpMyAdmin 4.6.4 (Aug 17, 2016)

  • Aside from the security fixes, bugs have been fixed affecting:
  • Create view when no view name specified
  • Changing a password
  • Fix deleting of users with non-English locales
  • Fixed password change on MariaDB without auth plugin

New in phpMyAdmin 4.6.3 (Jun 23, 2016)

  • includes the regularly scheduled maintenance
  • improvements and bug fixes.
  • In addition to bugs affecting particular version combinations, some of the other bugs fixed include:
  • Fixing cookie path on Windows
  • Fix MySQL SSL connections with some PHP versions
  • Fix listing of routines for non-privileged user

New in phpMyAdmin 4.6.2 (May 25, 2016)

  • A few of the many bugs fixed include:
  • Avoid using too log URLs when getting javascripts
  • Fixed setting mixed case languages (this prevented users from using certain translations)
  • Fix cookie path on IIS
  • Fix occassional 200 errors on Windows
  • Fixed export of ARCHIVE tables with keys
  • Add session reload for config authentication

New in phpMyAdmin 4.6.1 (May 3, 2016)

  • A few of the many bugs fixed include:
  • Problems with SQL syntax warnings from the linter/parser
  • Fixing an error about "PMA_Util" not found
  • Better handling of JSON columns
  • Fixed quoting with the SQL parser, which in particular adversely affected SQL imports and exports

New in phpMyAdmin 4.6.0 (Mar 22, 2016)

  • issue #11456 Disabled storage engines
  • issue #11479 Allow setting routine wise privileges
  • issue Hide Insert tab for non-updatable views
  • issue #11490 UI for defining partitioning in create table window
  • issue #11438 Support JSON data type
  • issue Editing partitions in table Structure
  • issue Tracking does not make sense for information_schema
  • issue #11550 Regression in Find and replace
  • issue #11619 TokuDB Tables Show Size as "unknown"
  • issue #11654 Use a slider for Internal relations
  • issue #11641 Ability to disable the navigationhiding Feature
  • issue #11647 Restrict configuration NavigationTreeDbSeparator to strings
  • issue #11667 Disable the tooltip in the navigation panel's filter box
  • issue Copy results to clipboard
  • issue #11504 Reactivate cut&paste possibility in print view
  • issue #11702 Extraneous message after edit + grid-edit
  • issue #11668 Table header is empty with browsing an empty table
  • issue #11701 Allow changing parameter order of routines
  • issue #11708 Remove no password warning
  • issue #11711 Clarify the meaning of "Stand-in structure for view" in SQL export
  • issue HTML line break shown after a MySQL connection error message
  • issue #11728 CSV import skip row count after
  • issue Fixed displaying of SQL query on table operations
  • issue #6321 Display binary strings as text if they are valid UTF-8
  • issue #11743 Display routine specific privileges
  • issue #11538 Copy multiple tables to database
  • issue Support Cloudflare Flexible SSL
  • issue Handle empty TABLE_COMMENT
  • issue #11833 Drop support for old Internet Explorer versions
  • issue #11796 Use modals for displaying forms in db structure page
  • issue #11789 Show MySQL error messages in user language
  • issue Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP >= 5.6
  • issue #11874 Show more used PHP extensions
  • issue #11874 Report when version check and error reporting are disabled
  • issue #11849 Fix PDF schema export
  • issue #11412 Remove ForceSSL configuration directive
  • issue Remove support for Mozilla Prism
  • issue #11412 Remove PmaAbsoluteUri configuration directive
  • issue #11914 Fix autoloading of phpseclib
  • issue #11880 Fixed rendering of missing extension error
  • issue #11923 Errors on Structure tab when user only has select access on certain columns
  • issue #11972 Missing documentation for $cfg['Servers'][$i]['favorite'] and $cfg['NumFavoriteTables']
  • issue #11907 Avoid displaying UPDATE query twice
  • issue #11850 Fixed CSV import
  • issue Fix SQL syntax highlighting in database search page
  • issue #12056 Fix error when we can not generate random string
  • issue #12055 Fixed PHP syntax error in templates
  • issue #12054 Fixed processing of queries with escaped quotes
  • issue #12041 Fixed exporting tables with fields DEFAULT and COMMENT
  • issue #12073 Hide edit and delete buttons when the results are not related to a table
  • issue #12083 Fixed parsing of field definition
  • issue #12081 Fixed rendering of table stats
  • issue #11705 Fixed problems with PHP on Windows on table structure
  • issue #12085 Like search strings being escaped incorrectly
  • issue #12092 Rename exported databases/tables doesn't seem to work
  • issue #12099 Undefined index: controllink
  • issue #12094 PHP Fatal error: Call to undefined function __()
  • issue #12098 Fix login after logout with http authentication
  • issue #12074 Fixed possible invalid SQL export
  • issue #12026 Fixed parsing of UNION SELECT with brackets
  • issue #12109 Fixed parsing of CREATE TABLE [AS] SELECT
  • issue #12105 Multi-server drap-and-drop import always fails
  • issue #12116 Fulltext indexes are not copied when using copy database function

New in phpMyAdmin 4.6.0 RC 1 (Mar 1, 2016)

  • A few highlights:
  • Allow setting routine-wise privileges
  • UI for defining partitioning in create table window
  • Support JSON data type
  • Editing partitions in table Structure
  • Copy results to clipboard
  • Reactivate cut&paste possibility in print view
  • Display binary strings as text if they are valid UTF-8
  • Copy multiple tables to database
  • Show MySQL error messages in user language

New in phpMyAdmin 4.5.5.1 (Mar 1, 2016)

  • This release fixes multiple XSS vulnerabilities, please see PMASA-2016-10, PMASA-2016-11, and PMASA-2016-12 for details;
  • additionally it fixes a vulnerability allowing man-in-the-middle attack on an API call to GitHub, see PMASA-2016-13 for details.
  • It also inclues fixes for the following bugs:
  • issue #11971 CREATE UNIQUE INDEX index type is not recognized by parser.
  • issue #11982 Row count wrong when grouping joined tables.
  • issue #12012 Column definition with default value and comment in CREATE TABLE exported faulty.
  • issue #12020 New statement but no delimiter and unexpected token with REPLACE.
  • issue #12029 Fixed incorrect usage of SQL parser context in SQL export
  • issue #12048 Fixed inclusion of gettext library from SQL parser

New in phpMyAdmin 4.5.5 (Feb 22, 2016)

  • Fixes include improvements to changing passwords on newer MariaDB servers and several fixes to the SQL parser which will resolve some errors users encountered entering commands in the SQL tab.

New in phpMyAdmin 4.6.0 Alpha 1 (Feb 10, 2016)

  • The phpMyAdmin team announces the release of 4.6.0-alpha1. Even though this release should be functional and relatively stable, it is considered an alpha release and encourage you to exercise care in deployment. Please report any issues at https://github.com/phpmyadmin/phpmyadmin/issues
  • Welcome to phpMyAdmin 4.6.0-alpha1, a regular maintenance release including over 35 improvements. Please note that this release ends support for old versions of Microsoft Internet Explorer, which are no longer supported by Microsoft. There is a new configuration directive, $cfg['Servers'][$i]['ssl_verify'] which is useful in some cases with self-signed certificates. The ForceSSL and PmaAbsoluteUri configuration directives have been removed (the functions of both of these should better be handled by the webserver than the application).
  • A complete list of new features and bugs that have been fixed is available in the ChangeLog file or changelog.php included with this release.
  • A few highlights:
  • Allow setting routine-wise privileges UI for defining partitioning in create table window
  • Support JSON data type
  • Editing partitions in table
  • Structure Copy results to clipboard
  • Reactivate cut&paste possibility in print view
  • Display binary strings as text if they are valid UTF-8
  • Copy multiple tables to database
  • Show MySQL error messages in user language

New in phpMyAdmin 4.5.4.1 (Jan 31, 2016)

  • issue #11892 Error with PMA 4.4.15.3
  • issue #11896 Remove hard dependency on phpseclib

New in phpMyAdmin 4.5.4 (Jan 28, 2016)

  • #11724 live data edit of big sets is not working
  • Table list not saved in db QBE bookmarked search
  • #11777 While 'changing a column', query fails with a syntax error after the 'CHARSET=' keyword
  • #11783 Avoid syntax error in javascript messages on invalid PHP setting for max_input_vars
  • #11784 Properly handle errors in upacking zip archive
  • #11785 Set PHP's internal encoding to UTF-8
  • #11786 Fixed Kanji encoding in some specific cases
  • #11787 Check whether iconv works before using it
  • #11788 Avoid conversion of MySQL error messages
  • #11792 Undefined index: parameters
  • #11802 Undefined index: field_name_orig
  • Undefined index: host
  • #11810 'Add to central columns' (per column button) does nothing
  • #11727 SQL duplicate entry error trying to INSERT in designer_settings table
  • #11798 Fix handling of databases with dot in a name
  • #11820 Fix hiding of page content behind menu
  • #11780 FROM clause not generated after loading search bookmark
  • #11826 Fix creating/editing VIEW with DEFINER containing special chars
  • #11828 Do not invoke FLUSH PRIVILEGES when server in --skip-grant-tables
  • #11804 Misleading message for configuration storage
  • #11772 Table pagination does nothing when session expired
  • #11840 Index comments not working properly
  • #11791 Better handle local storage errors
  • #11752 Improve detection of privileges for privilege adjusting
  • #11854 Undefined property: stdClass::$releases at version check when disabled in config
  • #11814 SQL comment and variable stripped from bookmark on save
  • Gracefully handle errors in regex based javascript search
  • [Security] Multiple full path disclosure vulnerabilities, see PMASA-2016-1
  • [Security] Unsafe generation of CSRF token, see PMASA-2016-2
  • [Security] Multiple XSS vulnerabilities, see PMASA-2016-3
  • [Security] Insecure password generation in JavaScript, see PMASA-2016-4
  • [Security] Unsafe comparison of CSRF token, see PMASA-2016-5
  • [Security] Multiple full path disclosure vulnerabilities, see PMASA-2016-6
  • [Security] XSS vulnerability in normalization page, see PMASA-2016-7
  • [Security] Full path disclosure vulnerability in SQL parser, see PMASA-2016-8
  • [Security] XSS vulnerability in SQL editor, see PMASA-2016-9

New in phpMyAdmin 4.5.3.1 (Dec 27, 2015)

  • issue #11774 Undefined offset 2
  • issue [Security] Path disclosure, see PMASA-2015-6

New in phpMyAdmin 4.5.3.0 (Dec 23, 2015)

  • issue #11744 Incomplete results of UNION ALL
  • issue #11742 MATCH AGAINST keywords not recognized
  • issue #11723 syntax verifier is not knowing "STRAIGHT_JOIN"
  • issue #11699 REPLACE() function confused with REPLACE statement
  • issue #11690 FLUSH word not recognized by parser
  • issue #11664 Online syntax verifier bug - "IF" on SELECT statement
  • issue #11665 Format breaks query with COUNT()
  • issue Undefinex index: SendErrorReports
  • issue Incorrect script name in include
  • issue #11685 Warning: Invalid argument supplied for foreach()
  • issue #11687 Delimiter missing while exporting multiple db routines
  • issue #11684 mysql_native_password with MariaDB bug
  • issue #11693 Flush privileges overusage - related to #11597
  • issue #11691 Query was empty on creating User in 4.5.2
  • issue #11695 PMA_getDataForDeleteUsers() warning
  • issue #11698 Cannot create user on Percona Server
  • issue Properly report error on connecting
  • issue #11706 Database export template not saving compression option
  • issue #11721 Fix single quote export for servers in ANSI_QUOTES mode
  • issue #11714 Avoid duplicite fetching of table information
  • issue #11724 Temporary fix for live data edit of big sets is not working
  • issue IE 8 compatibility in console
  • issue #11732 Exporting feature does not work with union table
  • issue #11728 CSV import skip row count after
  • issue #11679 Cannot export results of some queries
  • issue #11720 Message "An account already exists..." incorrectly displayed
  • issue #11758 Missing quoting of table in ALTER CONVERT query
  • issue #11752 PMA 4.5.2 breaks MySQL Master-Master Cluster
  • issue #11757 Export and preview show different SQL for character set
  • issue #11749 Fix possible undefined variables in table operations

New in phpMyAdmin 4.5.2.0 (Nov 23, 2015)

  • issue #11589 Incorrect parameter in mysqli_fetch_fields()
  • issue #11592 Missing headers in zipped export
  • issue #11590 Parser: Array to string conversion
  • issue #11597 Huge binary log growth on 4.5.x
  • issue #11594 'only_db' config option bug when db names contain underscore and are grouped
  • issue #11607 Unable to change password from Login information tab
  • issue #11610 Undefined variable: res_rel
  • issue #11611 Warning while exporting schema to PDF
  • issue #11612 Undefined index: new_row_format
  • issue #11605 Changing hostname kills password
  • issue #11614 Undefined variable: db
  • issue #11627 CREATE TABLE/INSERT INTO executed twice (ctrl+enter)
  • issue #11630 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
  • issue #11632 Exporting GIS visualization ignores start and row count
  • issue #11476 Errors instead of git info when PHP has no gzip support
  • issue #11633 CodeMirror tooltip shows below modal window
  • issue #11639 Bug with the MainBackground Color
  • issue Profiling checkbox is missing
  • issue #11642 Properly handle session expiry after POST requests
  • issue #11648 Notice in ./export.php#214 Undefined index: quick_or_custom
  • issue #11646 Unrecognized keywords
  • issue #11635 Sql not executed properly
  • issue #11631 Linter warnings when creating new user
  • issue #11626 wrong row count for query results
  • issue #11608 Analyzer doesn't recognize GRANT statements
  • issue #11602 Parser warnings (subqueries)
  • issue #11658 Collation column is empty in table Structure
  • issue #11661 Error changing table's column encoding

New in phpMyAdmin 4.5.1.0 (Oct 23, 2015)

  • issue Invalid argument supplied for foreach()
  • issue array_key_exists() expects parameter 2 to be array
  • issue #11480 Notice Undefined index: drop_database
  • issue #11486 Server variable edition in ANSI_QUOTES sql_mode: losing current value
  • issue #11491 Propose table structure broken
  • issue #11464 phpMyAdmin suggests upgrading to newer version not usable on that system
  • issue #11495 'PMA_Microhistory' is undefined
  • issue #11496 Incorrect definition for getTablesWhenOpen()
  • issue #11500 Error when creating new user on MariaDB 10.0.21
  • issue #11505 Notice on htmlspecialchars()
  • issue Notice in Structure page of views
  • issue #11510 AUTO_INCREMENT always exported when IF NOT EXISTS is on
  • issue #11516 Some partitions are missing in copied table
  • issue #11521 Notice of undefined variable when performing SHOW CREATE
  • issue #11509 Error exporting sql query results with table alias
  • issue #11512 SQL editing window does not recognise 'OUTER' keyword in 'LEFT OUTER JOIN'
  • issue #11518 "NOT IN" clause not recognized (MySQL 5.6 and 5.7)
  • issue #11524 Yellow star does not change in database Structure after add/remove from favorites
  • issue #11531 Invalid SQL in table definition when exporting table
  • issue #11526 Foreign key to other database's tables fails
  • issue #11519 Bug while exporting results when a joined table field name is in SELECT query
  • issue #11522 Strange behavior on table rename
  • issue #11539 Rename table does not result in refresh in left panel
  • issue #11541 Missing arguments for PMA_Table::generateAlter()
  • issue #11544 Notices about undefined indexes on structure pages of information_schema tables
  • issue Change minimum PHP version for Composer
  • issue #11542 Import parser and backslash
  • issue #11546 "Visualize GIS data" seems to be broken
  • issue #11548 Confirm box on "Reset slave" option
  • issue Fix cookies clearing on version change
  • issue #11558 Cannot execute SQL with subquery
  • issue #11520 Incorrect syntax creating a user using mysql_native_password with MariaDB
  • issue #11561 Cannot use third party auth plugins

New in phpMyAdmin 4.5.0.2 (Sep 25, 2015)

  • Fixed:
  • Incorrect indexes when exporting

New in phpMyAdmin 4.5.0.1 (Sep 24, 2015)

  • issue #11492 AUTO_INCREMENT statements are partly missing from exports

New in phpMyAdmin 4.5.0 (Sep 23, 2015)

  • Welcome to phpMyAdmin 4.5.0, which includes many improvements thanks to our Google
  • Summer of Code students and other contributors. With this release, the minimum required PHP version
  • is now 5.5 (older versions have reached End of Life and are no longer supported by the PHP development team).
  • Changes:
  • Improvements to the Console feature
  • Include structure in PDF export
  • Validate data before import
  • Support CHECKSUM TABLE operation
  • Improved operations regarding partitions
  • Alter privileges when renaming or copying a database or table
  • Several improvements related to speed and responsiveness
  • Improved print view
  • Use CTRL or ALT plus arrow keys to navigate in grid editor
  • Use plain-English destinations for $cfg['NavigationTreeDefaultTabTable'], $cfg['DefaultTabServer'],
  • $cfg['DefaultTabDatabase'], and $cfg['DefaultTabTable']. The old style values will still work, but this makes it easier for new users to easily understand the destination links.
  • Integrate SQL debugging into Console
  • Restore row editing when no unique/primary key exists
  • Allow exporting one file per table and one file per database
  • Improvements to using multiple servers with the auth_type cookie
  • Support virtual columns (MySQL 5.7.5+)
  • Add or improve support for several MariaDB features including process list and virtual/persistent columns
  • Improved handling of cached data when upgrading phpMyAdmin
  • Add SHA256 security password support

New in phpMyAdmin 4.4.15.0 (Sep 20, 2015)

  • issue #11411 Undefined "replace" function on numeric scalar
  • issue #11421 Stored-proc / routine - broken parameter parsing
  • issue Missing name for configuration read_as_multibytes
  • issue #11431 Incorrect "No row selected" message
  • issue #11447 MySQL 5.5 and the language system variable
  • issue #11452 Semantics of export and import icons are mixed up
  • issue #11451 Designer-Bug in move.js on multiple server configuration
  • issue #11458 Invalid UTF-8 sequence in argument
  • issue #11457 Request URI too large
  • issue Invalid argument supplied for foreach()
  • issue #11461 Foreign key constraints for InnoDB tables with upper-case letters disabled
  • issue #11487 Warning when entering Query page

New in phpMyAdmin 4.4.14.1 (Sep 13, 2015)

  • [security] reCaptcha bypass

New in phpMyAdmin 4.5.0 Beta 1 (Aug 31, 2015)

  • Improvements to the Console feature
  • Include structure in PDF export
  • Validate data before import
  • Support CHECKSUM TABLE operation
  • Improved operations regarding partitions
  • Alter privileges when renaming or copying a database or table
  • Several improvements related to speed and responsiveness
  • Improved print view
  • Use CTRL or ALT plus arrow keys to navigate in grid editor
  • Use plain-English destinations for $cfg['NavigationTreeDefaultTabTable'], $cfg['DefaultTabServer'],
  • cfg['DefaultTabDatabase'], and $cfg['DefaultTabTable']. The old style values will still work, but
  • this makes it easier for new users to easily understand the destination links.
  • Integrate SQL debugging into Console
  • Restore row editing when no unique/primary key exists
  • Allow exporting one file per table and one file per database
  • Improvements to using multiple servers with the auth_type cookie
  • Support virtual columns (MySQL 5.7.5+)
  • Add or improve support for several MariaDB features including process list and virtual/persistent columns
  • Improved handling of cached data when upgrading phpMyAdmin
  • Add SHA256 security password support

New in phpMyAdmin 4.4.14.0 (Aug 20, 2015)

  • issue #11367 Export after search, missing WHERE clause
  • issue #11380 Incomplete message after import
  • Incorrect scalar type declaration (reported under PHP 7)
  • issue #11389 ReCaptcha produces deprecated messages under PHP 7
  • issue #11387 phpseclib < 2.0 produces deprecated messages on PHP 7
  • issue #11404 "Switch to copied table" doesn't work
  • issue #11406 Missing quotes after calling "distinct values"
  • issue #11386 Cannot import database with long data in one column
  • issue #11410 SPATIAL index option is not clickable

New in phpMyAdmin 4.4.13.1 (Aug 9, 2015)

  • issue #11368 SQL error when importing phpMyAdmin dump file

New in phpMyAdmin 4.4.13 (Aug 8, 2015)

  • issue #1808 "Improve table structure" generates invalid SQL
  • issue Once checked "Show only active" checkbox is always checked
  • issue #1813 Delete rows using "Check All" is broken
  • issue Fix PHP 7 possible binding ambiguity
  • issue #11326 Exported schema includes all the tables of the database
  • issue #11339 Results not displayed if query ends in delimiter and comment
  • issue #11320 Live edit of data fields is not working always
  • issue Table list in navigation collapses when entering into a table in another page
  • issue #11364 JS error while trying to auto navigate to db structure page when db creation has failed

New in phpMyAdmin 4.4.12 (Jul 20, 2015)

  • bug: Saved chart image does not have a proper name or an extension
  • bug: #4976 Timepicker CSS issues in Original theme
  • bug: #4975 Move/Copy/Rename operations on Table/Db fail on Drizzle server
  • bug: #4826 Two inline edit windows
  • bug: #4979 Problem when import *.ods file
  • bug: Add missing head tag
  • bug: #4985 Column headers move when scrolling

New in phpMyAdmin 4.4.11 (Jul 13, 2015)

  • BUG FIXES:
  • bug Missing selected/entered values when editing active options in visual query builder
  • bug #4969 Autoload from prefs_storage not behaving properly
  • bug #4972 Incorrect length computed for binary data
  • bug Remove character set from create_tables_drizzle.sql
  • bug #4973 Users overview needs clarification
  • bug #4974 Creating a database from console doesn't update navigation panel
  • bug #4844 FAQ 1.17 needs an update

New in phpMyAdmin 4.4.10 (Jun 18, 2015)

  • bug #4950 Issues in database selection for replication
  • bug #4951 Trying to save chart as image crashes the browser
  • bug #4953 cant drag sql.gz file onto import input
  • bug #4960 Table creation results in GET request with missing server parameter that invalidates the session
  • bug #4961 Javascript error when Designer is opened
  • bug #4962 Insert by foreign key scrolls page to top
  • bug #4955 Clicking on the navi logo does not always work

New in phpMyAdmin 4.4.9 (Jun 5, 2015)

  • bug #4920 relation view doesn't list fields of table in other database
  • bug #4905 Sorting by an alias
  • bug #4931 False error before entering reCAPTCHA
  • bug #4909 central column with multiple server
  • bug #4937 Custom export with backquotes off is not working
  • bug #4908 Reverse proxy: infinite internal redirect (added warning in doc)
  • bug #4942 Export to gzip saves plain text under Chrome

New in phpMyAdmin 4.4.8 (May 28, 2015)

  • bug Allow accessing visual query builder when pmadb is not configured
  • bug #4893 Nav tree line alignment issue
  • bug #4911 Lock page icon is not shown after fresh reload
  • bug #4912 "Highlight pointer" and "Row marker" doesn't work properly
  • bug Browse foreigners window goes out of the window
  • bug #4918 Date field popup dialog position bug
  • bug In /setup, PMA_messages is not defined
  • bug #4924 Recaptcha failure
  • bug #4930 Database copy doesn't work for tables with more than one FULLTEXT index
  • bug #4929 Edit view structure doesn't load the algorithm
  • bug #4923 Do not limit table comments to 60 characters

New in phpMyAdmin 4.4.7 (May 18, 2015)

  • Bugfix:
  • bug #4876 Settings issues (Favorite tables shown twice in Settings)
  • bug #4896 Non-styled error page when following results link
  • bug #4894 Deleting without confirmation
  • bug #4858 Issues with SQL autocomplete
  • bug #4897 Column hint in SQL autocomplete is sometimes not shown
  • bug #4898 JS error after selecting a field and press Enter
  • bug Honor proxy settings when getting Git commit information
  • bug Missing title on link
  • bug #4512 ForceSSL Redirect Check
  • bug Undefined index collation_connection
  • bug Error when the reporting server is down
  • bug Escape database and table names for partition maintenance
  • bug Invalid value for CURLOPT_SSL_VERIFYPEER
  • bug #4367 Import status infinite loop
  • bug #4902 Designer: Loading does not work
  • bug #4904 Setup: Overview > Display does not work
  • bug #4906 Designer: pages from all databases

New in phpMyAdmin 4.4.6.1 (May 14, 2015)

  • bug #4899 [security] CSRF vulnerability in setup
  • bug #4900 [security] Vulnerability allowing man-in-the-middle attack

New in phpMyAdmin 4.4.6 (May 8, 2015)

  • bug #4890 webkitStorageInfo and webkitIndexedDB is deprecated
  • bug #4892 Undefined variable: unique_conditions
  • bug #4891 CSV Import ignores "Replace table data with file" checkbox

New in phpMyAdmin 4.4.5 (May 5, 2015)

  • Bug fixes:
  • Table overhead stats: missing space before the unit
  • Fix resize icon in Designer
  • Exit fullscreen in Designer does not change the button text
  • Designer icons missing when using original theme
  • Column list of central columns is not cleared
  • jQuery dialogs of the Designer are not displayed in fullscreen
  • Search function breaks when searching for certain combinations of backslashes and slashes
  • Maximum execution time exceeded in Util.class.php (better fix)
  • Some icons are above the overlay of jQuery dialogs
  • Clicking on external links in advisor rules give JS error
  • Filter in central columns does not work in other languages

New in phpMyAdmin 4.4.4 (Apr 27, 2015)

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

New in phpMyAdmin 4.4.3 (Apr 20, 2015)

  • bug #4851 PHP errors in login dialogue
  • bug #4845 White screen (Cloudflare)
  • bug #4207 json_encode error due to strftime returning non utf8 chars in Windows 8.1 Chinese version
  • bug #4794 Server error viewing table content
  • bug Fix issues related to number of decimal places in time
  • bug #4853 Relation view between 1600 and 1780 px
  • bug PHP 7 compatibility in php-gettext
  • bug PHP 7 compatibility in bfShapeFiles
  • bug PHP 7 session_regenerate_id() warning
  • bug #4857 Alter table after changing column name error
  • bug #4830 Maximum execution time exceeded in Util.class.php

New in phpMyAdmin 4.4.2 (Apr 14, 2015)

  • bug #4835 PMA_hideShowConnection not called after submit_num_fields
  • bug #4836 Server warning after moving from console to direct clicks
  • bug #4837 Duplicate new version notification when using the "Back" button
  • bug #4839 DOC link in setting is broken
  • bug #4841 Status page: Mislukte pogingen per uur value is incorrect
  • bug MIME Transformation link fixed
  • bug #4838 Prevents console window from moving out of the screen height
  • bug #4829 Create procedure via SQL Editor not more possible
  • bug #4833 CSS and Javascript are not compressed
  • bug #4849 Functions accessed from navigation do not load on ajax dialog
  • bug #4850 Relation view on 1920

New in phpMyAdmin 4.4.1.1 (Apr 8, 2015)

  • An urgent fix for 4.4.1.
  • Some debugging code slipped into the 4.4.1 codebase, producing messages in the web server's error log.

New in phpMyAdmin 4.4.1 (Apr 7, 2015)

  • Bug fixes:
  • bug #4813 MySQL 5.7.6 and the Users menu tab
  • bug #4818 MySQL 5.7.6 and changing the password for another user
  • bug #4819 Request URI too large
  • bug #4814 MySQL 5.7.6 and Databases
  • bugUse 'server' parameter in console to work in multi server environments
  • bug Missing tooltip in monitor
  • bug Missing sort icons in monitor
  • bug #4805 Inline edit broken when using functions in query
  • bug #4821 Timed-out import fails to restart when file represented
  • bug #4754 pMA DB not detected properly
  • bug #4825 Datepicker missing when changing number of rows on Insert page
  • bug #4824 INNODB STATUS page is empty
  • bug #4828 JavaScript is loaded in wrong order
  • bug #4827 TEXT formatting doesn't work after inline editing
  • bug #4822 Compress when php.ini output_buffering is active
  • bug #4832 Sorting distinct values result loses links
  • bug #4834 Do not attach token to css requests to improve caching

New in phpMyAdmin 4.4.0 (Apr 2, 2015)

  • Rename configuration directive from $cfg['NavigationTreeDisableDatabaseExpansion']
  • to $cfg['NavigationTreeEnableExpansion'] -- if used, please update your config.inc.php
  • Move the SQL scripts to create phpMyAdmin configuration storage from 'examples' to 'sql' directory
  • Upgrade Recaptcha to version 2 of the API
  • Added support for the SSL GRANT option
  • Improvements to the table structure and tracking pages
  • Improvements to the console feature
  • Improvements to the ZeroConf feature

New in phpMyAdmin 4.3.13 (Mar 30, 2015)

  • bug #4803 "Show hidden items" is sometimes hidden
  • bug #4807 Breaks when sorting by multiple columns while using UNION
  • bug #4798 Missing column when exporting in sql
  • bug #4810 Broken find and replace
  • bug #4804 Undefined Index after export schema
  • bug #4802 Changelog page is not working
  • bug #4815 Infinite calls to index.php
  • bug #4820 Invalid links to dev.mysql.com
  • bug #4718 simulate query fails, but actual query does not

New in phpMyAdmin 4.3.12 (Mar 23, 2015)

  • bug #4746 Right-aligned columns have left-aligned header
  • bug #4779 PMA_Util::parseEnumSetValues fails on enums with UTF-8 values
  • bug Undefined index savedsearcheswork
  • bug #4788 Inline edit of DATE fields with NULL, NULL checkbox is under datepicker
  • bug #4790 DROP TABLE/VIEW IF EXISTS are not tracked
  • bug Compatibility with central columns of version 4.4
  • bug #4758 Firefox with auth_type to http with multiple server doesn't work anymore
  • bug #4789 Views aren't dropped when copying a database
  • bug #4784 Incomplete bookmark saving
  • bug #4786 SELECT width on relations page

New in phpMyAdmin 4.4.0 Alpha 1 (Mar 5, 2015)

  • Rename configuration directive from $cfg['NavigationTreeDisableDatabaseExpansion'] to $cfg['NavigationTreeEnableExpansion'] -- if used, please update your config.inc.php
  • Move the SQL scripts to create phpMyAdmin configuration storage from 'examples' to 'sql' directory
  • Upgrade Recaptcha to version 2 of the API
  • Added support for the SSL GRANT option
  • Improvements to the table structure and tracking pages
  • Improvements to the console feature
  • Improvments to the ZeroConf feature

New in phpMyAdmin 4.3.11.1 (Mar 5, 2015)

  • bug [security] Risk of BREACH attack, see PMASA-2015-1

New in phpMyAdmin 4.3.11 (Mar 3, 2015)

  • bug #4774 SQL links are completely wrong
  • bug #4768 MariaDB: version mismatch
  • bug #4777 Some images are missing in Designer for original theme
  • bug #4767 Drizzle: undefined index in mysql_charsets.inc.php
  • bug #4753 Normal field and multi-line field have different margins
  • bug #4760 Cannot re-import settings from local storage
  • bug #4778 SQL error when database list is sorted by additional columns
  • bug #4780 Notice when timestamp column does not have default value

New in phpMyAdmin 4.3.10 (Feb 20, 2015)

  • bug Undefined index navwork
  • bug #4744 Opening console scroll down the page
  • bug Remove extra column heading in view structure page
  • bug Add missing confirmation when deleting central columns
  • bug Undefined index DisableIS
  • bug #4763 Database export with more than 512 tables fails
  • bug #4769 Previously set column aliases are destroyed if returned to the same table
  • bug #4752 Incorrect page after creating table
  • bug #4771 Central Columns not working, showing error

New in phpMyAdmin 4.3.9 (Feb 6, 2015)

  • bug #4728 Incorrect headings in routine editor
  • bug #4730 Notice while browsing tables when phpmyadmin pma database exists, but not all the tables
  • bug #4729 Display original field when using "Relational display column" option and display column is empty
  • bug #4734 Default values for binary fields do not support binary values
  • bug #4736 Changing display options breaks query highlighting
  • bug Undefined index submit_type
  • bug #4738 Header lose align when scrolling in Firefox
  • bug #4741 in ./libraries/Advisor.class.php#184 vsprintf(): Too few arguments
  • bug #4743 Unable to move cursor with keyboard in filter rows box
  • bug Incorrect link in doc
  • bug #4745 Tracking does not handle views properly
  • bug #4706 Schema export doesn't handle dots in db/table name
  • bug #3935 Table Header not displayed correct (Safari 5.0.5 Mac)
  • bug #4750 Disable renaming referenced columns
  • bug #4748 Column name center-aligned instead of left-aligned in Relations

New in phpMyAdmin 4.3.8 (Jan 27, 2015)

  • bug Undefined constant PMA_DRIZZLE
  • bug #4712 Wrongly positioned date-picker while Grid-Editing
  • bug #4714 Forced ORDER BY for own sql statements
  • bug #4721 Undefined property: stdClass::$version
  • bug #4719 'only_db' not working
  • bug #4700 Error text: Internal Server Error
  • bug #4722 Incorrect width table summary when favorite tables is disabled
  • bug #4710 Nav tree error after filtering the tables
  • bug #4716 Collapse all in navigation panel is sometimes broken
  • bug #4724 Cannot navigate in filtered table list
  • bug #4717 Database navigation menu broken when resolution/screen is changing
  • bug #4727 Collation column missing in database list when DisableIS is true
  • bug Undefined index central_columnswork
  • bug Undefined index favorite_tables

New in phpMyAdmin 4.3.7 (Jan 17, 2015)

  • bug #4694 js error on marking table as favorite in Safari (in private mode)
  • bug #4695 Changing $cfg['DefaultTabTable'] doesn't update link and title
  • bug Undefined index menuswork
  • bug Undefined index navwork
  • bug Undefined index central_columnswork
  • bug #4697 Server Status refresh not behaving as expected
  • bug Null argument in array_multisort()
  • bug #4699 Navigation panel should not hide icons based on 'TableNavigationLinksMode'
  • bug #4703 Unsaved schema page exported as pdf.pdf
  • bug #4707 Call to undefined method PMA_Schema_PDF::dieSchema()
  • bug #4702 URL is non RFC-2396 compatible in get_scripts.js.php

New in phpMyAdmin 4.3.6 (Jan 8, 2015)

  • bug Undefined index notices while configuring recent and favorite tables
  • bug #4687 Designer breaks without configuration storage
  • bug #4686 Select elements flicker and selects something else
  • bug #4689 Setup tool creates "pma__favorites" incorrectly
  • bug #4685 Call to a member function isUserType() on a non-object
  • bug #4691 Do not include console when no server is selected
  • bug #4688 File permissions in archive
  • bug #4692 Dynamic javascripts gives 500 when db selected

New in phpMyAdmin 4.3.5 (Jan 5, 2015)

  • bug Auto-configuration: tables were not created automatically
  • bug #4677 Advanced feature checker does not check for favorite tables feature
  • bug #4678 Some of the data stored in configuration storage are not deleted upon db or table delete
  • bug #4679 Setup does not allow providing a name for favorites table
  • bug #4680 Number of favorite table are not configurable in setup
  • bug #4681 'Central columns table' field in setup does not have a description
  • bug #4318 Default connection collation and sorting
  • bug #4683 Relational data is not properly updated on table rename
  • bug #4655 Undefined index: collation_connection (second patch)
  • bug #4682 4.3.3 & 4.3.4 Import sql created by mysqldump fails on foreign keys
  • bug #4676 Auto-configuration issues
  • bug #4416 New lines are removed when grid editing (part two: TEXT)

New in phpMyAdmin 4.3.4 (Dec 29, 2014)

  • bug #4653 Always connection error was shown, on /setup at tab "configuration s
  • torage"
  • bug #4661 Drag and drop file import always fails
  • bug #4651 don't open console with esc
  • bug #4664 select min() displays 1 row, but reports the table amount of rows re
  • turned
  • bug #4666 Undefined indexes in table stucture print view of a view
  • bug #4663 Export missing back ticks for order table name
  • bug #4668 Remove from central columns error
  • bug #4670 CSV import reads both commas and values into first column after firs
  • t row
  • bug #4642 phpmyadmin often fails to load due to specific load order
  • bug #4671 Unable to move all columns
  • bug #4645 Import of export created with mysqldump
  • bug #4672 "Distinct values" does not page
  • bug #4667 Consistency in borders
  • bug #4658 Illegal string offset (Data_length, Index_length)
  • bug #4655 Undefined index: collation_connection
  • bug #4673 Delimiter causing page lock

New in phpMyAdmin 4.3.3 (Dec 22, 2014)

  • bug The "Recently used tables" setting should be with Nav panel
  • bug #4647 Can't disable Favorites
  • bug #4646 Version Check Broken
  • bug #4630 AJAX request infinite loop
  • bug #4649 Attributes field size smaller than others
  • bug #4622 Cannot remove table ordering on a Mac
  • bug Fix initial replication configuration
  • bug Undefined index central_columnswork
  • bug #4657 Don't have default blowfish_secret
  • bug #4656 Some error popups fade away too quickly
  • bug #4648 Consistency in borders
  • bug $cfg['Error_Handler']['display'] no longer necessary
  • bug #4659 Leading and trailing whitespace in column name

New in phpMyAdmin 4.3.2 (Dec 13, 2014)

  • bug #4628 PHP error while exporting schema as PDF
  • bug #4631 Server selector submits two server parameter values
  • bug #4629 Problem with custom SQL queries using cookie authentication
  • bug: Undefined index central_columnswork
  • bug #4632 Notice in ./libraries/Util.class.php#1916 Undefined index: query
  • bug #4633 Wrong parameter in fetchValue
  • bug #4634 Error reporting creates an infinite loop
  • bug #4635 Token mismatch while creating configuration storage
  • bug #4640 Incorrect reference to PHP 6
  • bug #3794 failure to handle repeating empty columns when importing ODS
  • bug #4638 Default Export Method setting broken
  • bug #4639 Export SQL missing indentation first field
  • bug #4637 Field Alignment
  • bug #4644 Error when browsing tables

New in phpMyAdmin 4.3.1 (Dec 9, 2014)

  • bug #4609 'Show all' checkbox label is not clickable
  • bug #4610 JS error reporting: Hash fragment is reset
  • bug Undefined index menuswork
  • bug #4614 Separator between "Show All" and "Number of rows" disappears
  • bug #4615 SQL highlighting in process list breaks on auto refresh
  • bug #4616 Warning in db structure print view page
  • bug Undefined index navwork, savedsearcheswork, fields
  • bug #4620 Undefined index while adding to the central columns list
  • bug #4618 Page scrolls while GIS visualization is zoomed in/out with mousewheel
  • bug #4613 HHVM: method 'ob_gzhandler' not found
  • bug #4593 Manual "SELECT" doesn't change active table
  • bug #4623 Incomplete PHP OpenSSL support
  • bug #4626 Ctrl + click on a column not in sort triggers a server call to erron
  • eous url
  • bug #4625 "Insufficient space to save the file" on export SQL to file on server
  • bug #4627 "file_get_contents(examples/create_tables.sql): failed to open stream" after update
  • bug #4617 UI issues with sortable tables
  • bug #4619 SELECT LENGTH(`field`) FROM `table` does not sort

New in phpMyAdmin 4.3.0 (Dec 5, 2014)

  • Includes changes from the previous RC version

New in phpMyAdmin 4.2.13.1 (Dec 3, 2014)

  • bug #4612 [security] XSS vulnerability in redirection mechanism
  • bug #4611 [security] DOS attack with long passwords

New in phpMyAdmin 4.3.0 RC 1 (Nov 27, 2014)

  • 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 format
  • Range Search Capability
  • Improvements for the table editor (index creation)
  • PHP OpenSSL support for cookie encryption/decryption

New in phpMyAdmin 4.2.12 (Nov 24, 2014)

  • bug #4574 Blank/white page when JavaScript disabled
  • bug #4577 Multi row actions cause full page reloads
  • bug ReferenceError: targeurl is not defined
  • bug Incorrect text/icon display in Tracking report
  • bug #4404 Recordset return from procedure display nothing
  • bug #4584 Edit dialog for routines is too long for smaller displays
  • bug #4586 Javascript error after moving a column
  • bug #4576 Issue with long comments on table columns
  • bug #4599 Input field unnecessarily selected on focus
  • bug #4602 Exporting selected rows exports all rows of the query
  • bug #4444 No insert statement produced in SQL export for queries with alias
  • bug #4603 Field disabled when internal relations used
  • bug #4596 [security] XSS through exception stack
  • bug #4595 [security] Path traversal can lead to leakage of line count
  • bug #4578 [security] XSS vulnerability in table print view
  • bug #4579 [security] XSS vulnerability in zoom search page
  • bug #4594 [security] Path traversal in file inclusion of GIS factory
  • bug #4598 [security] XSS in multi submit
  • bug #4597 [security] XSS through pma_fontsize cookie

New in phpMyAdmin 4.2.11 (Nov 1, 2014)

  • bug ReferenceError: Table_onover is not defined
  • bug #4552 Incorrect routines display for database due to case insensitive checks
  • bug #4259 reCaptcha sound session expired problem
  • bug #4557 PHP fatal error, undefined function __()
  • bug #4568 Date displayed incorrectly when charting a timeline
  • bug #4571 Database Privileges link does not work
  • bug makegrid.js: where_clause is undefined
  • bug #4572 missing trailing slash (import and open_basedir)

New in phpMyAdmin 4.2.10.1 (Oct 22, 2014)

  • bug #4562 [security] XSS in debug SQL output
  • bug #4563 [security] XSS in monitor query analyzer

New in phpMyAdmin 4.2.10 (Oct 13, 2014)

  • bug #4361 Can't change font size (when config.inc.php not present)
  • bug #4542 Tab key in column name not shown
  • bug PDF export: title not present in PDF
  • bug #4543 Changing column name can break saved "order by" clause
  • bug #4545 trying to favorite table while browser localStorage is disabled thro
  • ws JS error
  • bug #4259 reCaptcha sound session expired problem
  • bug #4548 Inline editing a field converts tab to spaces
  • bug #4252 Database-level permission bug for db names containing underscores
  • bug #3120 Events are not exported when using xml
  • bug #4554 Grid-editing timestamp column forces datepicker
  • bug #4556 Fast filters for tables, views etc. should be governed by Navigation
  • TreeDisplayItemFilterMinimum

New in phpMyAdmin 4.2.9.1 (Oct 1, 2014)

  • bug #4544 [security] XSS vulnerabilities in table search and table structure pages

New in phpMyAdmin 4.2.9 (Sep 22, 2014)

  • 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 re
  • cords does not set all AUTO_INCREMENTs to 0 value
  • ajax.js responseHandler: another "cannot read property"
  • tbl_structure.js "cannot read property"

New in phpMyAdmin 4.2.8.1 (Sep 15, 2014)

  • [security] DOM based XSS that results to a CSRF that creates a ROOT account in certain conditions

New in phpMyAdmin 4.2.8 (Sep 1, 2014)

  • Bugfix release:
  • bug #4516 Odd export behavior
  • bug #4519 Uncaught TypeError: Cannot read property 'success' of null
  • bug #4520 sql.js: cannot read property
  • bug #4521 Initially allowed chart types do not match selected data
  • bug #4518 Export to SQL: CREATE TABLE option AUTO_INCREMENT ignored
  • bug #4522 Duplicate column names while assigning index
  • bug #4487 Export of partitioned table does not import
  • bug server_privileges.js: cannot read property
  • bug #4527 Importing ODS files with column names having trailing spaces fails
  • bug #4413 Navigation Error in Nav Tree for Search Results Past the First Page
  • bug functions.js: Cannot read property 'replace' of undefined

New in phpMyAdmin 4.2.7.1 (Aug 18, 2014)

  • bug #4501 [security] XSS in table browse page
  • bug #4502 [security] Self-XSS in enum value editor
  • bug #4503 [security] Self-XSSes in monitor
  • bug #4504 [security] Self-XSS in query charts
  • bug #4505 [security] XSS in view operations page
  • bug #4517 [security] XSS in relation view

New in phpMyAdmin 4.2.7 (Jul 31, 2014)

  • bug - Broken links on home page
  • bug #4494 Overlap in navigation panel
  • bug #4427 Action icons not in horizontal order
  • bug #4493 s_attention.png is missing
  • bug #4499 Uncaught TypeError: Cannot call method 'substr' of undefined
  • bug #4498 PMA 4.2.x and HHVM
  • bug #4500 mysql_doc_template is not defined

New in phpMyAdmin 4.2.6 (Jul 18, 2014)

  • bug #4471 Undefined index warning with referenced column.
  • bug #4027 $cfg['MaxExactCount'] is ignored when BROWSING is back
  • bug #4482 Multi Column sorting (improved user experience)
  • bug #4478 Server validation does not work while in setup/mysqli
  • bug Undefined variable when grid editing a foreign key column
  • bug #4481 mult_submits.inc.php Undefined variable Error
  • bug #4485 Sorting breaks the copy column feature
  • bug #4440 Javascript error when renaming table
  • bug #4483 'New window' link (selflink) disappears, causing Javascript error
  • bug #4489 Incorrect detection of privileges for routine creation
  • bug #4459 First few characters of database name aren't clickable when expanded
  • bug #4486 [security] XSS injection due to unescaped table comment
  • bug #4488 [security] XSS injection due to unescaped table name (triggers)
  • bug #4492 [security] XSS in AJAX confirmation messages
  • bug #4491 [security] Missing validation for accessing User groups feature

New in phpMyAdmin 4.2.5 (Jun 27, 2014)

  • bug #4467 shell_exec() has been disabled for security reasons
  • bug #4470 Error while submitting empty query
  • bug #4463 Fatal error: Class 'PMA_DatabaseInterface' not found
  • bug #4469 Fixed cookie based login for installations without mcrypt
  • bug #4473 incorrect result count when having clause is used
  • mcrypt: remove the requirement (64-bit) and the related warning

New in phpMyAdmin 4.2.4 (Jun 21, 2014)

  • bug #4449 Mediawiki export does not produce table header row; also fix related
  • PHP warnings
  • bug #4442 New lines are added to query every time
  • bug #4445 Fatal error on SQL Export of join query
  • bug #4448 Dump binary columns in hexadecimal notation not working
  • Regenerate cookie encryption IV for every session
  • bug #4405 Cannot import (open_basedir): fix another case
  • bug #4457 SQL tab - Insert queries not showing affected row count
  • bug Missing warning about existing account, on multi-server config
  • bug #4435 WHERE clause can be undefined
  • bug SQL export views as tables option getting ignored
  • bug #4464 [security] XSS injection due to unescaped db/table name in navigation hiding
  • bug #4465 [security] XSS injection due to unescaped db/table name in recent/favorite tables

New in phpMyAdmin 4.2.3 (Jun 9, 2014)

  • bug #4423 Moving fields not working
  • bug #4424 Table indexes disappear after altering field
  • bug #4432 Error while displaying chart at server level
  • bug #4405 Cannot import (open_basedir)
  • bug #4396 Problem copying constraints (such as Sakila)
  • bug #4433 Missing privileges submenu
  • bug #4394 Drop db confirmation message when dropping a user
  • bug #4436 Insert form numeric field with function drop-down list
  • bug #4437 Problems due to missing enforcement of the minimum supported MySQL version
  • Add enforcement of the minimum supported PHP version (5.3.0)
  • bug: Query error on submitting a column change form containing a disabled
  • input field
  • bug: Incorrect menu tab generation from usergroups
  • bug: Missing space in index creation/edit generated query
  • bug #4434 Unchecking 'Show SQL queries' results NaN

New in phpMyAdmin 4.2.2 (May 21, 2014)

  • bug #4388 Disable database expansion when enabled throws Error 500 when database name is clicked in navigation tree
  • bug #4414 table display of performance_schema DB structure
  • bug #4411 Protect Binary Columns: many problems
  • bug #4395 BLOB link transformation is broken
  • bug Respect ['ShowCreateDb'] in the navi panel
  • bug #4392 Cannot see databases in nav panel on databases grouping when disabled database expansion
  • bug #4419 No more calendar into search tab
  • bug #4398 Monitor should fit into screen width
  • bug #4418 When copying databases, primary key attributes get lost
  • bug #4421 empty maxInputVars on js/messages.php

New in phpMyAdmin 4.2.0 (May 8, 2014)

  • rfe #1403 Export only triggers
  • rfe #1483 Export Server/Database/Table without triggers
  • rfe #1662 Add table comment tool tip in database structure page
  • rfe #1447 Single table for display Character Sets and Collations
  • rfe #1455 Display icons/text/both for the table row actions
  • rfe #1473 Transformation to convert Boolean value to text
  • bug #4157 Changing users password will delete it
  • rfe #1474 Text transformation combines Append and Prepend
  • Added warning about the mysql extension being deprecated and removed the extension directive
  • Added support for scatter charts
  • rfe #1478 Make Column Headings Sticky
  • rfe #1480 Enhance privileges initials table
  • rfe #1472 [interface] Break "Edit privileges" with sub-menus
  • rfe #1466 Minor refactoring required
  • rfe #1004 Create indexes at the end in SQL export
  • rfe #1479 Relations edit form for larger monitors
  • rfe #1475 Inline query box vertical resize
  • rfe #1500 [interface] Add bottom border to top menu container
  • rfe #1498 Add datepicker for 'TIME' type
  • bug #4237 HTTP Referer disclosure in SQL links
  • rfe: Show full names on navigation hover
  • rfe #1505 Behaviour on click on a routine in nav panel
  • rfe #1418 Support more than one separating character on CSV import
  • rfe #569 Load/Save Query By Example
  • bug #4281 Grid edit ENUM field, dialog disappears when trying to select
  • bug #4304 DB export using zip compression generates an empty archive
  • rfe #1508 confirmation message at the top
  • bug #4306 breadcrubs wrong on table create
  • rfe #1511 better validate database name for copying
  • rfe #1510 Database tab "Drop" button should be a link
  • rfe #1513 Highlight required form fields after failed submission
  • rfe #1460 Redirect to login page after session has expired
  • bug #4316 Grid edit: can't change month on date fields
  • rfe #1501 add maxlength by field with length-spec
  • rfe #1512 Import happily doesn't do anything with no file name provided
  • rfe #1514 Add function to all the insert boxes automatically
  • rfe #1515 Option to skip tables larger than n
  • rfe #1486 Possibility of disabling database expansion
  • rfe #1476 Favourite tables select box
  • rfe #420 $cfg['CharEditing']='textarea' for structure edit
  • rfe #1329 Avoid editing of fields which are part of relation
  • rfe: [interface] Highlight active left menu item in setup
  • rfe: Filter on-screen rows during Browse
  • Removed support for SQL Validator (SOAP service no longer offered)
  • bug #4352 Settings > Manage: incorrect messages
  • bug #4337 "More" in Actions area doesn't collapse to fit available space
  • bug #4375 Group two DB, one's name is the prefix of the other one
  • bug #4070 Confusing database/table grouping
  • bug #4366 Creating Index doesn't update index-list

New in phpMyAdmin 4.2.0 RC 1 (Apr 28, 2014)

  • bug #4375 Group two DB, one's name is the prefix of the other one
  • bug #4070 Confusing database/table grouping
  • bug #4366 Creating Index doesn't update index-list
  • Includes changes from the previous Beta version

New in phpMyAdmin 4.1.14 (Apr 28, 2014)

  • bug #4365 Creating bookmark with multiple queries not working
  • bug #4375 Group two DB, one's name is the prefix of the other one
  • bug #4376 [interface] Login fields show in separate line
  • bug #4372 Changing browser transformation results in unnecessary table rebuild

New in phpMyAdmin 4.2.0 Beta 1 (Apr 22, 2014)

  • rfe #1403 Export only triggers
  • rfe #1483 Export Server/Database/Table without triggers
  • rfe #1662 Add table comment tool tip in database structure page
  • rfe #1447 Single table for display Character Sets and Collations
  • rfe #1455 Display icons/text/both for the table row actions
  • rfe #1473 Transformation to convert Boolean value to text
  • bug #4157 Changing users password will delete it
  • rfe #1474 Text transformation combines Append and Prepend
  • Added warning about the mysql extension being deprecated
  • and removed the extension directive
  • Added support for scatter charts
  • rfe #1478 Make Column Headings Sticky
  • rfe #1480 Enhance privileges initials table
  • rfe #1472 [interface] Break "Edit privileges" with sub-menus
  • rfe #1466 Minor refactoring required
  • rfe #1004 Create indexes at the end in SQL export
  • rfe #1479 Relations edit form for larger monitors
  • rfe #1475 Inline query box vertical resize
  • rfe #1500 [interface] Add bottom border to top menu container
  • rfe #1498 Add datepicker for 'TIME' type
  • bug #4237 HTTP Referer disclosure in SQL links
  • rfe Show full names on navigation hover
  • rfe #1505 Behaviour on click on a routine in nav panel
  • rfe #1418 Support more than one separating character on CSV import
  • rfe #569 Load/Save Query By Example
  • bug #4281 Grid edit ENUM field, dialog disappears when trying to select
  • bug #4304 DB export using zip compression generates an empty archive
  • rfe #1508 confirmation message at the top
  • bug #4306 breadcrubs wrong on table create
  • rfe #1511 better validate database name for copying
  • rfe #1510 Database tab "Drop" button should be a link
  • rfe #1513 Highlight required form fields after failed submission
  • rfe #1460 Redirect to login page after session has expired
  • bug #4316 Grid edit: can't change month on date fields
  • rfe #1501 add maxlength by field with length-spec
  • rfe #1512 Import happily doesn't do anything with no file name provided
  • rfe #1514 Add function to all the insert boxes automatically
  • rfe #1515 Option to skip tables larger than n
  • rfe #1486 Possibility of disabling database expansion
  • rfe #1476 Favourite tables select box
  • rfe #420 $cfg['CharEditing']='textarea' for structure edit
  • rfe #1329 Avoid editing of fields which are part of relation
  • rfe [interface] Highlight active left menu item in setup
  • rfe Filter on-screen rows during Browse
  • Removed support for SQL Validator (SOAP service no longer offered)
  • bug #4352 Settings > Manage: incorrect messages
  • bug #4337 "More" in Actions area doesn't collapse to fit available space

New in phpMyAdmin 4.1.13 (Apr 14, 2014)

  • bug #4279 CTRL + up or down moves 2 fields
  • bug #4336 List server css style wrong
  • bug Missing value on the Status > Server page
  • bug #4347 Fixed PHP Parse error in Advisor
  • bug #4350 Deleting the DB if it is renamed by the same name
  • bug #4353 makeProfilingChart is not defined
  • bug #4355 Precision specifier for DOUBLE type is truncated
  • bug #4346 Incorrect "Export incomplete" message
  • bug #4359 Notices on create table page
  • bug #4356 GROUPed selects show number of rows as if not grouped
  • bug #4357 JS Form submitted on "enter" even if focus is inside a select field

New in phpMyAdmin 4.2.0 Alpha 1 (Apr 10, 2014)

  • rfe #1403 Export only triggers
  • rfe #1483 Export Server/Database/Table without triggers
  • rfe #1662 Add table comment tool tip in database structure page
  • rfe #1447 Single table for display Character Sets and Collations
  • rfe #1455 Display icons/text/both for the table row actions
  • rfe #1473 Transformation to convert Boolean value to text
  • bug #4157 Changing users password will delete it
  • rfe #1474 Text transformation combines Append and Prepend
  • Added warning about the mysql extension being deprecated
  • and removed the extension directive
  • Added support for scatter charts
  • rfe #1478 Make Column Headings Sticky
  • rfe #1480 Enhance privileges initials table
  • rfe #1472 [interface] Break "Edit privileges" with sub-menus
  • rfe #1466 Minor refactoring required
  • rfe #1004 Create indexes at the end in SQL export
  • rfe #1479 Relations edit form for larger monitors
  • rfe #1475 Inline query box vertical resize
  • rfe #1500 [interface] Add bottom border to top menu container
  • rfe #1498 Add datepicker for 'TIME' type
  • bug #4237 HTTP Referer disclosure in SQL links
  • rfe Show full names on navigation hover
  • rfe #1505 Behaviour on click on a routine in nav panel
  • rfe #1418 Support more than one separating character on CSV import
  • rfe #569 Load/Save Query By Example
  • bug #4281 Grid edit ENUM field, dialog disappears when trying to select
  • bug #4304 DB export using zip compression generates an empty archive
  • rfe #1508 confirmation message at the top
  • bug #4306 breadcrubs wrong on table create
  • rfe #1511 better validate database name for copying
  • rfe #1510 Database tab "Drop" button should be a link
  • rfe #1513 Highlight required form fields after failed submission
  • rfe #1460 Redirect to login page after session has expired
  • bug #4316 Grid edit: can't change month on date fields
  • rfe #1501 add maxlength by field with length-spec
  • rfe #1512 Import happily doesn't do anything with no file name provided
  • rfe #1514 Add function to all the insert boxes automatically
  • rfe #1515 Option to skip tables larger than n
  • rfe #1486 Possibility of disabling database expansion
  • rfe #1476 Favourite tables select box
  • rfe #420 $cfg['CharEditing']='textarea' for structure edit
  • rfe #1329 Avoid editing of fields which are part of relation
  • rfe [interface] Highlight active left menu item in setup
  • rfe Filter on-screen rows during Browse
  • Removed support for SQL Validator (SOAP service no longer offered)
  • bug #4352 Settings > Manage: incorrect messages

New in phpMyAdmin 4.1.12 (Mar 27, 2014)

  • Add event : datepicker won't open
  • Fix missing value error while executing SQL query
  • TCPDF library is now optional dependency
  • Cannot find the import plugins which start with uppercase 'I'

New in phpMyAdmin 4.1.11 (Mar 24, 2014)

  • bug #4335 reCaptcha problem (4.1.10 regression)

New in phpMyAdmin 4.1.10 (Mar 24, 2014)

  • bug #4301 Grid edit: "SELECT" query is replaced by "UPDATE" query after edit
  • bug #4278 reCaptcha re-login requires double effort
  • bug #4324 Datepicker not showing up on insert page
  • bug #3991 Problem selecting item in select boxes with the ENTER keystroke in s
  • ome browsers
  • bug #4323 QueryWindow ignores CodeMirror
  • bug None of the live charts shown on "Status -> Monitor" (Chrome)

New in phpMyAdmin 4.1.9 (Mar 7, 2014)

  • bug #4279 CTRL + up or down moves two fields (part one)
  • bug #4294 output as text radio clickable for "OpenDocument Text" export
  • bug #4297 DROP DATABASE tick box in export no longer works
  • bug #4291 Unable to export comments in OpenDocument text format
  • bug #4299 Deletion even when the user says "No" to the confirmation message
  • bug #4303 "New" link in navi panel is shown even if no privileges
  • bug #4302 Some params are being omitted from microhistory
  • bug #4298 Missing validation on Import CSV: "Columns enclosed with" and "Columns escaped with"
  • bug #4040 Fatal error while resetting settings
  • bug #4305 JS error when editing procedure from nav panel
  • bug #4308 Edit routine form submitting when pressing enter
  • bug #4307 Nav: "Columns" won't expand with specific schema

New in phpMyAdmin 4.1.8 (Feb 24, 2014)

  • bug #4276 Login loop on session expiry
  • bug #4249 Incorrect number of result rows for SQL with subqueries
  • bug #4275 Broken Link to php extension manual
  • bug #4053 List of procedures is not displayed after executing with Enter
  • bug #4081 Setup page content shifted to the right edge of its tabs
  • bug #4284 Reordering a column erases comments for other columns
  • bug #4286 Open "Browse" in a new tab
  • bug #4287 Printview - Always one column too much
  • bug #4288 Expand database (+ icon) after timeout doesn't do anything
  • bug #4285 Fixed CSS for setup
  • Fixed altering table to DOUBLE/FLOAT field
  • bug #4292 Success message and failure message being shown together
  • bug #4293 opening new tab (using selflink) for import.php based actions results in error and logout

New in phpMyAdmin 4.1.7 (Feb 10, 2014)

  • bug #4245 initial Browse query does not match sorting order
  • bug #4250 Notice on export page
  • bug #4253 "New" text in navigation frame acts like a database
  • bug #4262 Cannot define a column with fractional seconds
  • bug #4265 Missing datepicker icon for DATETIME(length)
  • bug #4257 Hide fractional seconds when applicable
  • bug #4264 Uncheck "Ignore" while inserting, upon leaving a textarea
  • bug #4260 reCaptcha is ignoring language settings
  • bug #4259 reCaptcha sound session expired problem
  • bug #4263 Japanese character encoding not working properly when exporting
  • bug #4269 Notice on table relation page
  • bug #4270 Bad text-color for table comments
  • bug #4278 reCaptcha re-login requires double effort
  • bug #4272 Incorrect tabindex
  • bug #4271 Query by example and the second criteria line
  • bug #4242 Wildcard-containing only_db failure in sidebar

New in phpMyAdmin 4.1.6 (Jan 27, 2014)

  • bug #4232 User not found after creating the user
  • bug #4241 Confusing dialog when trying to create an already existing user
  • bug #4239 Missing LIMIT clause for some queries
  • rfe #1489 Do not show create icon when user has no privileges
  • bug #4218 Chrome behavior with date fields
  • bug #3579 NOW() function incorrectly selected (regression)
  • bug #4244 Advisor complaints about MariaDB 10.x is version less than 5.1
  • bug #3889 When login fails and error display is active, login data is
  • displayed (regression)
  • bug #4247 open_basedir warnings on export page
  • bug #4013 AJAX request waiting until version info is retrieved
  • bug #4248 js error when changing number of columns in status monitor

New in phpMyAdmin 4.1.5 (Jan 18, 2014)

  • bug #3780 Allow aborting loading pages
  • bug #4223 Database list: Create database misses collation column
  • bug #4224 Empty table names when a table is "inuse"
  • bug #4225 Partition maintenance broken
  • bug #4219 Table list (left panel) does not reload when table renamed
  • bug #4230 "in use" displayed for all views in database print view
  • bug #4226 Notice: Undefined index: pma_config_loading
  • bug #4221 Bzip2 export cannot be directly imported (so withdraw bz2 export)
  • bug #4204 Reloading user privileges hides user groups submenu
  • bug #4231 DATE columns quick edit decrement by one day

New in phpMyAdmin 4.1.4 (Jan 8, 2014)

  • bug #3840 (additional fix) When exporting to gzip format, the data is compress
  • ed 2 times
  • bug #4209 Missing compression in one case
  • bug #4208 Can't browse tables after sorting on columns with fieldnames that ha
  • ve a '-'
  • bug #4184 Switch to wrong page after adding an index
  • bug #3885 Additional fix for this bug
  • bug #4212 Table "disappears" if it has the same name as its tablegroup
  • bug #4213 Datetime Quick Edit decrements by one day
  • bug #4217 Current value not highlighted when browsing foreign values
  • bug #4220 Incorrect key values in foreign key browser
  • bug #4215 MariaDB 5.5: error in Drizzle detection

New in phpMyAdmin 4.1.3 (Jan 3, 2014)

  • bug #3938 PDFDefaultPageSize doc and easy configurability
  • bug #4198 Hovering over pie chart gives fatal JS error
  • bug #4200 Missing syntax highlighting
  • bug #4201 Exports are not compressed
  • bug #4131 Import: "number of rows to skip" is ambiguous
  • bug #4205 Add a user shows additional "edit user group" link
  • bug #4202 Cannot read property 'token' of undefined
  • bug #4203 On refreshing designer, $.FullScreen is undefined
  • bug #3920 Lost space in navigation area

New in phpMyAdmin 4.1.2 (Dec 23, 2013)

  • bug #4178 Quick edit for BIT type does not work
  • bug #2760 Warn about incomplete exports
  • bug #4190 Fractional seconds cause row update even if the value is not changed
  • bug #4170 Overflow scroll for table grid is not a good solution
  • bug #2961 Relations settings not updated on config change
  • bug #4187 SQL query inline edit doesn't post changes on the first run
  • rfe #1465 Docs for connections to IPv6 only MySQL instances
  • rfe #1468 [interface] No floating for server breadcrumb menu

New in phpMyAdmin 4.1.1 (Dec 17, 2013)

  • bug #4154 Error using UNION query
  • bug #4173 Transformations overview not reachable
  • bug #4149 Js freezes in the management of replication
  • bug #3903 Query fails when using aliases after ordering result
  • bug #4181 Adding columns in table creation clears existing columns
  • bug #4023 Requires wildcard EXECUTE/ALTER ROUTINE on DB to allow
  • Procedures to be executed by user
  • bug #4186 Adding a column when creating a table does not propagate index info
  • bug #4185 Unable to execute create procedure statement from query window

New in phpMyAdmin 4.1.0 (Dec 12, 2013)

  • Includes changes from the previous RC version

New in phpMyAdmin 4.0.10 (Dec 5, 2013)

  • Clicking database name in query window opens a new tab
  • Wrong page is shown after editing; also, do not show a modal dialog for multi-row edit
  • PHP NavigationTree error when paging through list
  • Support A10 Networks load balancer
  • Row deleting isn't binlogs friendly
  • Setup script does not recognize manually-configured server
  • Events page says no privileges with ALL PRIVILEGES

New in phpMyAdmin 4.1.0 RC 2 (Dec 2, 2013)

  • Allow specifying a port when connecting to the controlhost
  • User interface improvements to server privileges, view creation, the
  • Operations tab, Relation View, and when creating new users.
  • Added support for AES_ENCRYPT on BLOB columns
  • Added support for relations with ndbcluser
  • Added optional ReCAPTCHA support during login
  • Added support for fractional seconds in time, datetime, and timestamp columns
  • Added find and replace by column
  • Added the Error Reporting Component, an optional feature allowing users to report certain errors directly to the phpMyAdmin bug team.
  • Added configurable menus (so an administrator can hide certain features)

New in phpMyAdmin 4.0.9 (Nov 5, 2013)

  • Includesc changes from the previous RC version

New in phpMyAdmin 4.1.0 Beta 2 (Nov 5, 2013)

  • This release contains many improvements and bug fixes. With this release the minimum supported PHP version is now 5.3. The final 4.1.0 release will require a minimum MySQL version of 5.5.
  • A few highlights include:
  • Allow specifying a port when connecting to the controlhost
  • User interface improvements to server privileges, view creation, the
  • Operations tab, Relation View, and when creating new users.
  • Added support for AES_ENCRYPT on BLOB fields
  • Added support for relations with ndbcluser
  • Added optional ReCAPTCHA support during login
  • Added support for fractional seconds in time, datetime, and timestamp
  • fields
  • Added find and replace by column
  • Added the Error Reporting Component, an optional feature allowing
  • users to report certain errors directly to the phpMyAdmin bug team.
  • Added configurable menus (so an administrator can hide certain
  • features)

New in phpMyAdmin 4.0.9 RC 1 (Nov 1, 2013)

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

New in phpMyAdmin 4.1.0 Beta 1 (Oct 17, 2013)

  • Includes changes from the previous Alpha version

New in phpMyAdmin 4.0.8 (Oct 7, 2013)

  • Includes changes from the previous RC version

New in phpMyAdmin 4.0.8 RC 1 (Oct 2, 2013)

  • bug #3988 Rename view is not working
  • bug #4041 Interaction between linkified fields and grid editing
  • bug #3975 Table grouping isn't implemented properly
  • bug #4060 Browser tries to remember wrong password when creating new user
  • bug #4002 Edit Index on big table doesn't show "Loading" or any message
  • bug #4098 Default table tab is ignored
  • bug #4099 Server/library difference warning: setting is ignored
  • bug #4100 table tree group strategy
  • bug #4102 ALTER TABLE ORDER BY and InnoDB
  • bug #4103 Tracking report: cannot delete a statement
  • bug #3996 Drizzle navigation doesn't expand
  • bug #4074 GIS column editor: point not displayed
  • bug #4109 Drizzle tables in navigation are shown as views
  • bug #4095 NUL symbols added to the end of database dump file
  • bug #4105 More disappears in table Structure
  • bug #3992 Multi-row edit doesn't clear values when checking NULL

New in phpMyAdmin 4.1.0 Alpha 1 (Oct 1, 2013)

  • rfe #499 On user creation, warn if the user already exists
  • Use indeterminate check all checkbox in server privileges
  • Break server_status.php functions into smaller functions
  • PMA_DBI functions in database_interface.lib.php renamed to be compliant with PEAR standards
  • [interface] Make warning about existing config directory clearer
  • rfe #1414 Allow specifying controlport
  • PMA_DBI functions in database interface libraries renamed to be compliant with PEAR standards
  • rfe #1412 Creating a view from an empty set of results
  • Improved layout on db and table operations pages
  • rfe #1410 Added support for AES_ENCRYPT for blob fields
  • rfe #1423 Clarify option text for icon/text settings
  • [interface] Upgraded CodeMirror to 3.x series
  • rfe #1363 Improved query profiler
  • [interface] rfe #1429 Better suggestion for database name
  • rfe #1433 Support relations with ndbcluster
  • bug #3962 Proper escaping of JSON export
  • rfe #1382 Optional ReCAPTCHA support
  • rfe #1434 Improvements to the table browsing navigation bar
  • rfe #1233 and rfe #1283 Improvements to Relation View interface
  • rfe #1397 Use fractional seconds in time, datetime, and timestamp
  • rfe #175 Allow cross-database relations
  • [core] Dropped support for PHP 5.2.
  • rfe #487 and rfe #1405 Find and Replacing column wise
  • rfe #1373 Use same create view dialog for editing a view
  • rfe #316 Configurable menus; allow user groups with customized menus per group
  • bug #4024 Editing field a record is selected by makes pma load forever
  • bug #4035 Query "inline" link disappears when turning off "Explain SQL" option
  • rfe #1385 Hide tables, functions, procedures, events and views in navigation tree
  • rfe #1321 Export view as if it was a table
  • Dropped configuration directive: SQP
  • Dropped configuration directive: MySQLManual*
  • rfe #1041 and bug #2954 Improved support for SSL connections between MySQL and phpMyAdmin
  • bug #4056 Language: Vague error message when adding a varchar field
  • [setup] rfe #1452 Use type="password" for server passwords
  • rfe #1451 HTML5 input tag enhancements
  • bug #1193 Text field too small when editing a row longer than $cfg['LimitChars
  • Privileges tab for table level
  • bug #4068 Headline in operations not readable in IE10
  • bug #4000 "Table does not contain unique column" message appears after adding a unique column
  • rfe #1428 add 'new database' entry to nav tree
  • rfe #1457 Stone Age icon found
  • rfe #1463 Filter tables and databases by regular expression
  • Change the proxy variable names in the config to remove the VersionCheck prefix from them
  • Added an Error Reporting Component
  • Javascript files are no longer uglified

New in phpMyAdmin 4.0.7 (Sep 24, 2013)

  • Includes changes from the previous RC version

New in phpMyAdmin 4.0.7 RC 1 (Sep 18, 2013)

  • bug #3993 Sorting in database overview with statistics doesn't work
  • bug Handle the situation where PHP_SELF is not set
  • bug #4080 Overwrite existing file not obeyed
  • bug #3929 Database-specific privileges are not copied when cloning user
  • bug #3997 Error handling in case MySQL extension is missing
  • bug #4089 Moving Columns will alter column definition
  • bug #4091 Insert ignore option does not work
  • bug #4090 Downloading BLOB downloads page template
  • bug #4092 Clicking on table name in view of information_schema redirects to wr
  • ong page
  • bug #4079 Copy Table Add AUTO_INCREMENT value checkbox not working
  • bug #4088 MySQL server version at index.php incorrect w/ controlhost
  • bug #4001 Import error: Class 'ImportOds' not found
  • bug #3986 Missing DROP VIEW button

New in phpMyAdmin 4.0.6 (Sep 6, 2013)

  • bug #4036 Call to undefined function mb_detect_encoding (clarify the doc)
  • bug Missing hints when changing a column's structure
  • bug #4048 Cannot select foreign value in Search
  • bug #4025 gzip export is not actually compressed with mod_deflate
  • bug #4054 query analysis doesn't launch in status monitor
  • Add pmahomme icon credits (FamFamFam silk icon set)
  • bug #4064 Table structure statistics "Space usage" caption too small for l10n
  • bug #4051 Wrong tabindex when inserting rows
  • bug #4066 varchar field not truncated in table browse mode
  • rfe #1435 Opening database should expand it in the navigation menu
  • (performance) Removed ShowTooltip directive
  • bug #4046 Exporting huge Tables causes memory-Problems

New in phpMyAdmin 4.0.6 RC 2 (Aug 31, 2013)

  • Exporting huge Tables causes memory-Problems

New in phpMyAdmin 4.0.6 RC 1 (Aug 28, 2013)

  • bug #4036 Call to undefined function mb_detect_encoding (clarify the doc)
  • bug Missing hints when changing a column's structure
  • bug #4048 Cannot select foreign value in Search
  • bug #4025 gzip export is not actually compressed with mod_deflate
  • bug #4054 query analysis doesn't launch in status monitor
  • Add pmahomme icon credits (FamFamFam silk icon set)
  • bug #4064 Table structure statistics "Space usage" caption too small for l10n
  • bug #4051 Wrong tabindex when inserting rows
  • bug #4066 varchar field not truncated in table browse mode
  • rfe #1435 Opening database should expand it in the navigation menu
  • performance) Removed ShowTooltip directive

New in phpMyAdmin 4.0.5 (Aug 5, 2013)

  • bug #3977 Not detected configuration storage
  • bug #3970 Pressing enter in the filter field reloads page
  • bug #3984 Cannot insert in this table (PHP < 5.4)
  • bug #3989 Reloading privileges does not update the interface
  • bug #3960 NavigationBarIconic config not honored
  • bug #3985 Call to undefined function mb_detect_encoding
  • bug #4007 Analyze option not shown for InnoDB tables
  • bug #4015 Forcing a storage engine for configuration storage
  • bug Incorrect Drizzle 7 detection
  • bug #4019 Create database if not exists (export): add an option to the
  • interface to enable generating CREATE DATABASE and USE (false by default)
  • bug #4012 Crash on CSV file import
  • bug #4009 Statistic Monitor shows only last 3 digits in graph
  • bug #3998 Non-permanent SQL history not working
  • bug #3578 Transformations for text/plain on a BLOB column
  • [security] Improved protection against cross framing, see PMASA-2013-10
  • Reinstated configuration directive: AllowThirdPartyFraming

New in phpMyAdmin 4.0.5 RC 2 (Jul 30, 2013)

  • [security] Improved protection against cross framing
  • Reinstated configuration directive: AllowThirdPartyFraming

New in phpMyAdmin 4.0.5 RC 1 (Jul 29, 2013)

  • bug #3977 Not detected configuration storage
  • bug #3970 Pressing enter in the filter field reloads page
  • bug #3984 Cannot insert in this table (PHP < 5.4)
  • bug #3989 Reloading privileges does not update the interface
  • bug #3960 NavigationBarIconic config not honored
  • bug #3985 Call to undefined function mb_detect_encoding
  • bug #4007 Analyze option not shown for InnoDB tables
  • bug #4015 Forcing a storage engine for configuration storage
  • bug Incorrect Drizzle 7 detection
  • bug #4019 Create database if not exists (export): add an option to the
  • interface to enable generating CREATE DATABASE and USE (false by default)
  • bug #4012 Crash on CSV file import
  • bug #4009 Statistic Monitor shows only last 3 digits in graph
  • bug #3998 Non-permanent SQL history not working
  • bug #3578 Transformations for text/plain on a BLOB column

New in phpMyAdmin 4.0.4.2 (Jul 29, 2013)

  • Fix stored XSS in Server status monitor, see PMASA-2013-9
  • Fix stored XSS in navigation panel logo link, see PMASA-2013-9
  • Fix self-XSS in setup, trusted proxies validation, see PMASA-2013-9
  • Fix full path disclosure, see PMASA-2013-12
  • Fix control user SQL injection in pmd_pdf.php, see PMASA-2013-15
  • Fix control user SQL injection in schema_export.php, see PMASA-2013-15
  • Fix self-XSS in schema export, see PMASA-2013-14
  • Fix unencoded json object, see PMASA-2013-11
  • Fix stored XSS in link transformation plugin, see PMASA-2013-13

New in phpMyAdmin 4.0.4.1 (Jul 1, 2013)

  • [security] Global variables scope injection vulnerability (see PMASA-2013-7)

New in phpMyAdmin 4.0.4 (Jun 18, 2013)

  • bug #3959 Using DefaultTabDatabase in NavigationTree for Database Click
  • bug #3961 Avoid Suhosin warning when in simulation mode
  • bug #3897 Row Statistics and Space usage bugs
  • bug #3966 Only display "table has no unique column" message when applicable
  • bug #3960 NavigationBarIconic config not honored
  • bug #3965 Default language wrong with zh-TW
  • bug #3921 Call to undefined function PMA_isSuperuser() if default server is
  • not set
  • bug #3971 Ctrl/shift + click opens links in same window
  • bug #3964 Import using https does not work
  • bug Missing removeCRLF option in ExportCsv and ExportExcel plugins
  • bug #3631 Drop not working Visio schema export.
  • bug #3645 Better handling of invalid ODS documents
  • bug #3976 Number of pages
  • bug #3922 User privileges, database name unescaped

New in phpMyAdmin 4.0.4 RC 1 (Jun 14, 2013)

  • bug #3959 Using DefaultTabDatabase in NavigationTree for Database Click
  • bug #3961 Avoid Suhosin warning when in simulation mode
  • bug #3897 Row Statistics and Space usage bugs
  • bug #3966 Only display "table has no unique column" message when applicable
  • bug #3960 NavigationBarIconic config not honored
  • bug #3965 Default language wrong with zh-TW
  • bug #3921 Call to undefined function PMA_isSuperuser() if default server is
  • not set
  • bug #3971 Ctrl/shift + click opens links in same window
  • bug #3964 Import using https does not work
  • bug Missing removeCRLF option in ExportCsv and ExportExcel plugins
  • bug #3631 Drop not working Visio schema export.
  • bug #3645 Better handling of invalid ODS documents
  • bug #3976 Number of pages
  • bug #3922 User privileges, database name unescaped

New in phpMyAdmin 4.0.3 RC 1 (Jun 1, 2013)

  • bug #3941 Recent tables list always empty
  • bug #3933 Do not translate "Open Document" in export settings
  • bug #3927 List of tables is missing after expanding in the navigation frame
  • bug #3942 Warnings about reserved word for many non reserved words
  • bug #3912 Exporting row selection, resulted by ORDER BY query
  • bug #3957 Cookies must be enabled past this point
  • bug #3956 "Browse foreign values" search filter / page selector not working
  • bug #3579 NOW() function incorrectly selected (partial regression)
  • [security] Javascript execution vulnerability in Create view, reported by Maxim Rupp (see PMASA-2013-6)

New in phpMyAdmin 4.0.2 RC 1 (May 21, 2013)

  • bug #3902 Cannot browse when table name contains keyword "call"
  • center loading indicator for navigation refresh, related to bug #3920
  • bug #3925 Table sorting in navigation panel is case-sensitive
  • bug #3915 Import of CSV file (Replace table data with file) with duplicate values
  • bug #3907 undefined variables, function parameter problems
  • bug #3898 Structure not refreshed after column drop
  • bug #3926 View is not updatable
  • bug #3919 PropertiesIconic not honored
  • bug #3930 Databases to choose for specific privileges show up escaped
  • bug #3910 Export database with empty table as a php array, does not produce valid PHP
  • bug #3936 Query profiler chart not loading from SQL Query page
  • bug #3946 Missing CSV import option "Do not abort on INSERT error"
  • bug #3943 Missing Operations>Table options>AUTO_INCREMENT
  • bug Missing CREATE DATABASE statement when exporting at database level
  • bug #3924 Show warning when CSV file does not contain data for all columns
  • bug #3947 Missing Sql Query after modify structure
  • bug #3948 Server export problems
  • bug #3917 CountTables directive is deprecated

New in phpMyAdmin 4.0.1 (May 15, 2013)

  • bug #3879 Import broken for CSV using LOAD DATA
  • bug #3889 When login fails and error display is active, login data is displayed
  • bug #3890 [import] Web server upload directory import fails
  • bug #3891 [import] Server upload folder import file name missing in success message
  • rfe #1421 [auth] Add retry button on connection failure with config auth
  • bug #3894 [interface] Provide feedback if no columns selected for multi-submit
  • bug #3799 [interface] Incorrect select field change on ctrl key navigation in
  • Firefox
  • bug #3885 [browse] display_binary_as_hex option causes unexpected behavior
  • bug #3899 Git commit links to Github missing
  • bug #3900 CSP WARN in Firefox console
  • bug #3901 Setup script warning for config auth (stored login data) shows link
  • BBcode
  • bug #3895 [browse] Fixed getting BLOB data
  • bug #3905 [export] Custom Exporting exports all databases
  • bug #3909 [import] Import of CSV FIle to selected table doesn't work
  • bug #3904 Browsing an empty table should not display its Structure
  • bug #3908 Calendar widget improperly redirects to home
  • bug #3916 [interface] Missing scrollbar (original theme)
  • [vendor] add tcpdf path to vendor_config.php
  • bug fix compat with tcpdf >= 6.0 (tested with 6.0.012)

New in phpMyAdmin 4.0.0 (May 7, 2013)

  • Contains many bug fixes and smaller new features;
  • Moreover, the documentation has a new look and contains an index.

New in phpMyAdmin 3.5.8.1 (Apr 24, 2013)

  • [security] Remote code execution (preg_replace)
  • [security] Locally Saved SQL Dump File Multiple File Extension Remote Code Execution, reported by Janek Vind (see PMASA-2013-3)

New in phpMyAdmin 3.5.8.0 (Apr 8, 2013)

  • bug #3828 MariaDB reported as MySQL
  • bug #3854 Incorrect header for Safari 6.0
  • bug #3705 Attempt to open trigger for edit gives NULL
  • Use HTML5 DOCTYPE
  • [security] Self-XSS on GIS visualisation page, reported by Janek Vind
  • bug #3800 Incorrect keyhandler behaviour #2

New in phpMyAdmin 4.0.0 Beta 2 (Mar 17, 2013)

  • bug #2951 [export] Correctly export decimal fields.
  • bug #3762 [core] Make Advisor work on Windows withou COM extension.
  • bug #3519 [export] Prevent infinite recursion in PDF export.
  • bug #3827 Table specific privileges not displayed for db name containing
  • underscore
  • rfe #1386 Add IF NOT EXISTS clause when copying database
  • No longer package .travis.yml configuration file when creating a release.
  • bug #3830 Can't export custom query because it lowercases table names
  • bug #3829 Enabling query profiling crashes javascript based navigation
  • rfe #879 Reserved word warning
  • Remove the database ordering sub-feature of the only_db directive

New in phpMyAdmin 3.5.7.0 (Feb 15, 2013)

  • bug #3779 [core] Problem with backslash in enum fields
  • bug #3816 Missing server_processlist.php
  • bug #3821 Safari: white page
  • Correct detection of the Chrome browser

New in phpMyAdmin 4.0.0 Beta 1 (Feb 11, 2013)

  • With this version, the HTML frames are gone and the navigation panel now presents a tree. This version requires Javascript.

New in phpMyAdmin 4.0.0 Alpha 2 (Jan 28, 2013)

  • Patch #3481047 for rfe #3480477 Insert as new row enhancement
  • Patch #3480999 Activate codemirror in the query window
  • Patch #3495284 XML Import - fix message and redirect
  • rfe #3484063 Null checkbox behavior
  • Patch #3497179 Contest-5: Add user: Allow create DB w/same name + grant u_%
  • Patch #3498201 Contest-6: Export all privileges
  • Patch #3502814 for rfe #3187077 Change password buttons should match
  • rfe #3488640 Expand table-group in non-light navigation frame if only one
  • Patch #3509360 Contest-3: Option "Truncate table" before "insert"
  • Patch #3506552 Contest-2: Show index information in the data dictionary
  • Patch #3510656 Contest-1: Ignoring foreign keys while dropping tables
  • Bug #3509686 Reverting sort on joined column does not work
  • New transformation: append string
  • rfe #3507804 Session upload progress (PHP 5.4)
  • rfe #3488185 draggable columns vs copy column name
  • Patch #3507001 Contest-4: Textarea for large character columns
  • Removed the PHP version of the ENUM editor
  • Patch #3507111 Display distinct results, linked to corresponding data rows
  • bug #3507917 [export] JSON has unescaped values for allegedly numeric columns
  • rfe #3516187 show tables creation, last update, last check timestamps in db_structure
  • bug #3059806 Supporting running from CIFS/Samba shares
  • bug #3516341 [export] Open Document Text, Word and Texy! Text show table structure twice
  • bug [export] Texy! Text: Columns containing Pipe Character don't export properly
  • export] Show triggers in Open Document Text, Word and Texy! Text
  • Patch #3415061 [auth] Login screen appears under the page
  • rfe #3517354 [interface] Allow disabling CodeMirror with $cfg['CodemirrorEnable'] = false
  • rfe #3475567 [interface] New directive $cfg['HideStructureActions']
  • bug #3468272 [import] Fixed import of ODS with more paragraphs in a cell
  • bug #3510196 [core] Improved redirecting with ForceSSL option
  • rfe #3518852 [edit] edit blob but not other binary, new option $cfg['ProtectBinary'] = 'noblob'
  • Hide language select box if there are no locales installed
  • Removed some directives: verbose_check, SuggestDBName, LightTabs,
  • VerboseMultiSubmit, ReplaceHelpImg
  • Patch #3500882 Fixing checkbox behaviour while editing identical rows
  • rfe #3441722 [interface] Display description of datatypes
  • rfe #3517835 [structure] Move columns easily
  • Ajaxified "Create View" functionality
  • [import] New plugin: import mediawiki
  • New navigation system
  • Discontinued the use of a frame-based layout
  • rfe #3528994 [interface] Allow wrapping possibly long values in replication-status table
  • interface] Autoselect username input on cookie login page
  • bug #3563799 [interface] Grid editing destroying huge amount of data
  • import] Remove support for the unactive docSQL import format
  • bug #3577443 [edit] "Browse foreign values" does not show on ajax edit
  • rfe #3522109 [browse] Grid editing: action to trigger it (or disable)
  • bug #3526598 [interface] SQL query not shown when creating table
  • Dropped configuration directive: AllowThirdPartyFraming
  • Dropped configuration directive: LeftFrameLight
  • Dropped configuration directive: DisplayDatabasesList
  • Dropped configuration directives: ShowTooltipAliasDB and ShowTooltipAliasTB
  • Dropped configuration directive: NaviDatabaseNameColor
  • Added configuration directive: MaxNavigationItems
  • Renamed configuration directive: LeftFrameDBTree => NavigationTreeEnableGrouping
  • Renamed configuration directive: LeftFrameDBSeparator => NavigationTreeDbSeparator
  • Renamed configuration directive: LeftFrameTableSeparator => NavigationTreeTableSeparator
  • Renamed configuration directive: LeftFrameTableLevel => NavigationTreeTableLevel
  • Renamed configuration directive: LeftPointerEnable => NavigationTreePointerEnable
  • Renamed configuration directive: LeftDefaultTabTable => NavigationTreeDefaultTabTable
  • Renamed configuration directive: LeftDisplayTableFilterMinimum => NavigationTreeDisplayTableFilterMinimum
  • Renamed configuration directive: LeftDisplayLogo => NavigationDisplayLogo
  • Renamed configuration directive: LeftLogoLink => NavigationLogoLink
  • Renamed configuration directive: LeftLogoLinkWindow => NavigationLogoLinkWindow
  • Renamed configuration directive: LeftDisplayServers => NavigationDisplayServers
  • Renamed configuration directive: LeftRecentTable => NumRecentTables
  • Renamed configuration directive: LeftDisplayDatabaseFilterMinimum => NavigationTreeDisplayDbFilterMinimum
  • Removed the "Mark row on click" feature; must now click the checkbox to mark
  • Removed the "Synchronize" feature
  • Improved layout of server variables page
  • rfe #1052091 [config] Double-underscores in PMA table names
  • Improved the "More" dropdown on the table structure page
  • interface] Added "scroll to top" link in menubar
  • designer] Fullscreen mode for the designer
  • Upgraded jquery to v1.8.3 and jquery-ui to v1.9.2
  • Patch #3597529 [status] Add raw value as title on server status page
  • Support MySQL 5.6 partitioning
  • Removed the AjaxEnable directive
  • rfe #3542567 Accept IPv6 ranges and IPv6 CIDR notations in $cfg['Servers'][$i]['AllowDeny']['rules']
  • Bug #3576788 Grid editing shows the value before silent truncation
  • Upgraded jqPlot to 1.0.4 r1121
  • Upgraded to jquery-ui-timepicker-addon 1.1.1
  • rfe #3599046 [interface] Added comments for indexes
  • Replaced qtip with jQuery UI tooltip
  • Upgraded CodeMirror to 2.37

New in phpMyAdmin 3.5.6.0 (Jan 28, 2013)

  • bug #3593604 [status] Erroneous advisor rule
  • bug #3596070 [status] localStorage broken in server status monitor
  • bug #3598736 [routines] Editing a procedure with special characters
  • bug #3600322 [core] Visualize GIS data throws Fatal Error
  • bug #3599362 [core] Double-escaped error message
  • bug #3776 [cookies] Login without auth on second server

New in phpMyAdmin 4.0.0 Alpha 1 (Jan 23, 2013)

  • Welcome to the first alpha release for phpMyAdmin 4.0.0. With this version, the HTML frames are gone and the navigation panel now presents a tree. This version requires Javascript.
  • Version 4.0 contains many bug fixes and smaller new features; moreover, the documentation has a new look and contains an index. Enjoy!

New in phpMyAdmin 3.5.5.0 (Dec 21, 2012)

  • bug #3563824 [export] Support Apache's mod_deflate
  • bug #3585523 [interface] Inline query editing broken after row update
  • bug #3586389 [setup] Cannot switch language in /setup
  • bug #3585695 [CSS] Font size in inline query editor is way too big
  • bug #3588354 [l10n] Portuguese Language not displaying correctly
  • bug #3591412 [status] Live charts don't work for non-default server
  • bug [core] Proxy ajax calls to pma.net to avoid browser notices
  • bug #3593534 [tracking] Structure Snapshot on tracked view renders invalid
  • SQL
  • bug #3544366 [events] Event comments not saved

New in phpMyAdmin 3.5.5.0 RC 1 (Dec 14, 2012)

  • bug #3563824 [export] Support Apache's mod_deflate
  • bug #3585523 [interface] Inline query editing broken after row update
  • bug #3586389 [setup] Cannot switch language in /setup
  • bug #3585695 [CSS] Font size in inline query editor is way too big
  • bug #3588354 [l10n] Portuguese Language not displaying correctly
  • bug #3591412 [status] Live charts don't work for non-default server
  • bug [core] Proxy ajax calls to pma.net to avoid browser notices
  • bug #3593534 [tracking] Structure Snapshot on tracked view renders invalid
  • SQL
  • bug #3544366 [events] Event comments not saved

New in phpMyAdmin 3.5.4.0 (Nov 17, 2012)

  • bug #3570212 [edit] uuid_short() is a no-arguments function
  • bug #3569577 [edit] Add routine parameter headers not valid for "function"
  • bug #3575799 [search] Various search operators not working as expected
  • bug #3576322 [search] Invalid select query generated for tables with ENUM file
  • bug #3577468 [display] Incorrect imagejpeg Syntax Breaks Image Transformation
  • bug #3578776 [search] Editing SQL not possible when no records found
  • bug #3571970 [interface] Display chart and number of rows to plot
  • bug #3582631 [core] Wrong redirect url caused cookies error with ForceSSL

New in phpMyAdmin 3.5.4.0 RC 1 (Nov 9, 2012)

  • bug #3570212 [edit] uuid_short() is a no-arguments function
  • bug #3569577 [edit] Add routine parameter headers not valid for "function"
  • bug #3575799 [search] Various search operators not working as expected
  • bug #3576322 [search] Invalid select query generated for tables with ENUM fields
  • bug #3577468 [display] Incorrect imagejpeg Syntax Breaks Image Transformation
  • bug #3578776 [search] Editing SQL not possible when no records found
  • bug #3571970 [interface] Display chart and number of rows to plot
  • bug #3582631 [core] Wrong redirect url caused cookies error with ForceSSL

New in phpMyAdmin 3.5.3.0 (Oct 9, 2012)

  • bug #3539044 [interface] Browse mode "Show" button gives blank page if no resu
  • lts anymore
  • bug #3534979 [interface] Copy Database Ajax feedback vanishes long before copy
  • ing is done
  • bug #3527531 [interface] GC-maxlifetime warning incorrectly displayed
  • bug #3526916 [interface] Search fails with JS error when tooltips disabled
  • bug #3544366 [interface] Event comments not saved
  • bug #3549084 [edit] Can't enter date directly when editing inline
  • bug #3548491 [interface] Inline query editor doesn't work from search results
  • bug #3547825 [edit] BLOB download no longer works
  • bug #3541966 [config] Error in generated configuration arrray
  • bug #3553551 [GUI] Invalid HTML code in multi submits confirmation form
  • interface] Designer sometimes places tables on the top menu
  • bug #3546277 [core] Call to undefined function __() when config file has wrong
  • permissions
  • bug #3540922 [edit] Error searching table with many fields
  • bug #3555104 [edit] Cannot copy a DB with table and views
  • bug #3559925 [privileges] Incorrect updating of the list of users
  • bug #3561224 [edit] cell edit date field with empty date fills in current date
  • bug #3559955 [edit] current_date from function drop down fails on update
  • bug #3562472 add support for Solaris and FreeBSD system load and memory displa
  • y in server status
  • bug #3553068 [import] Table import from XML file fails
  • replace Highcharts with jqplot for Display chart
  • bug #3567684 [edit] Pasting value doesn't clear null checkbox
  • bug #3570786 [edit] Datepicker for date and datetime fields is broken

New in phpMyAdmin 3.5.2.2 (Aug 13, 2012)

  • [security] Fixed XSS vulnerabilities

New in phpMyAdmin 3.5.2.1 (Aug 4, 2012)

  • [security] Fixed local path disclosure vulnerability, see PMASA-2012-3

New in phpMyAdmin 3.5.2 (Jul 9, 2012)

  • bug #3521416 [interface] JS error when editing index
  • bug #3521313 [core] Call to undefined function __()
  • bug #3521016 [edit] NOW() function incorrectly selected
  • bug [GUI] Invalid HTML code on transformation_overview.php
  • bug #3522930 [browse] Missing validation in Ajax mode
  • bug Fix popup message on build SQL of import
  • bug #3523499 [core] Make X-WebKit-CSP work better
  • replace Highcharts with jqplot for query profiling, zoom search
  • bug #3531584 [interface] No form validation in change password dialog
  • bug #3531585 [interface] Broken password validation in copy user form
  • bug #3531586 [unterface] Add user form prints JSON when user presses enter
  • bug #3534121 [config] duplicate line in config.sample.inc.php
  • bug #3534311 [interface] Grid editing incorrectly parses ENUM/SET values
  • bug #3510196 [core] More clever URL rewriting with ForceSSL

New in phpMyAdmin 3.5.1 (May 4, 2012)

  • bug #3510784 [edit] Limit clause ignored when sort order is remembered
  • bug #3511471 [interface] View name not seen in navi panel (MySQL 5.1)
  • bug #3512916 [display] Right frame reloads after displaying SQL result(zero ro
  • ws)
  • bug [interface] Fixed missing Codemirror for inline query edit when exporting
  • a result set
  • bug #3514490 [auth] Multiple Navigation panels bug still present
  • bug #3515181 [users] Error in create user + underscore + create database
  • bug #3515666 [display] Profiling chart shows wrong data
  • bug #3516037 [auth] JS includes missing in auth config error page
  • bug #3516183 [display] Missing image extension
  • bug [display] Added missing icons in original theme
  • bug #3516761 [edit] Query error after search
  • bug #3516405 [display] Chart title is getting wrong within chart export
  • bug #3517021 [interface] Header links except 'More' hide after closing dialog
  • bug #3516817 [interface] "More" actions in table structure
  • bug #3518484 [privileges] PMA_sqlAddSlashes() does not quote the table names c
  • orrectly
  • bug #3518983 [designer] Error messages do not appear in the Designer
  • bug #3519747 [interface] Suhosin patch warning incorrectly displayed
  • bug #3520107 [interface] Server status page: Incorrect dialog box titles
  • bug #3516089 [structure] DROP does not work on defective VIEWs

New in phpMyAdmin 3.5.0 (Apr 9, 2012)

  • 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

New in phpMyAdmin 3.4.10.2 (Mar 30, 2012)

  • [security] Fixed local path disclosure vulnerability, see PMASA-2012-2

New in phpMyAdmin 3.4.10.1 (Feb 20, 2012)

  • [security] XSS in replication setup, see PMASA-2012-1

New in phpMyAdmin 3.4.10 (Feb 15, 2012)

  • bug #3460090 [interface] TextareaAutoSelect feature broken
  • patch #3375984 [export] PHP Array export might generate invalid php code
  • bug #3049209 [import] Import from ODS ignores cell that is the same as cell before
  • bug #3463933 [display] SELECT DISTINCT displays wrong total records found
  • patch #3458944 [operations] copy table data missing SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
  • bug #3469254 [edit] Setting data to NULL and drop-downs
  • bug #3477063 [edit] Missing set fields and values in generated INSERT query
  • bug #3460867 [libraries] license issue with TCPDF (updated to 5.9.145)

New in phpMyAdmin 3.5.0 Beta 1 (Jan 27, 2012)

  • rfe #2021981 [interface] Add support for mass prefix change.
  • "up to date" message on main page when current version is up to date
  • Update to jQuery 1.6.2
  • Patch #3256122 [search] Show/hide db search results
  • Patch #3302354 Add gettext wrappers around a message
  • Remove deprecated function PMA_DBI_get_fields
  • rfe #2098927 Remember recent tables
  • rfe #3078542 Remember the last sort order for each table
  • AJAX for Create table in navigation panel
  • rfe #3310562 Wording about Column
  • AJAX for Add a user in Database privileges
  • Patch #3271804 for rfe #3177495, new DisableMultiTableMaintenance directive
  • interface] Reorganised server status page.
  • interface] Changed way of generating charts.
  • rfe #939233 [interface] Flexible column width
  • interface] Mouse-based column reordering in query results
  • AJAX for Insert to a table from database Structure page
  • Patch #3316969 PMA_ajaxShowMessage() does not respect timeout
  • AJAX for Change on multiple rows in table Browse
  • interface] Improved support for stored routines
  • display] More options for browsing GIS data
  • interface] Support for spatial indexes
  • display] GIS data visualization
  • AJAX for table structure multiple-column change
  • AJAX for table structure index edit
  • Show/hide indexes in table Structure
  • More compact navigation bar
  • Display direction (horizontal/vertical) no longer displayed by default
  • Shift/click support in database Structure
  • Show/hide column in table Browse
  • bug #3353856 [AJAX] AJAX dialogs use wrong font-size
  • bug #3354356 [interface] Timepicker does not work in AJAX dialogs
  • AJAX for table Structure Indexes Edit
  • AJAX for table Structure column Change
  • interface] Improved support for events
  • interface] Improved support for triggers
  • interface] Improved server monitoring
  • AJAX for table Structure column Add
  • AJAX for table Operations copy table
  • bug #3380946 [export] no uid Query result export (Suhosin limit)
  • Grid editing in browse mode (replaces row inline edit)
  • Zoom-search in table Search
  • interface] Editor for GIS data
  • import] Import GIS data from ESRI Shapefiles
  • interface] 'Function based search' for GIS data
  • Support Drizzle database
  • bug #3356456 [interface] Interface problems for queries having LIMIT clauses
  • interface] Remove DefaultPropDisplay feature
  • bug #3299486 [prettyprint] Order By in a query containing comment character
  • interface] Improved ENUM/SET editor
  • patch #3428376 [pmadb] pmadb on a different MySQL server
  • patch #3410688 [interface] Improving field size for character columns
  • usability] Removed an unnecessary AJAX request from database search
  • bug #3302419 [navi] Tabs break when squeezing page
  • rfe #3406797 [navi] Stick table tools to top of page on scroll
  • rfe #1632106 [interface] Improved error handling
  • patch #3432835 [interface] Add useful intermediate pages to pageselector
  • interface] Improved index editor
  • View editing via a generated ALTER VIEW
  • bug #3408377 [interface] Deleting table from the DB does not change the table counter
  • rfe #3438266 [designer] Toggle for relation lines
  • bug #3442069 [AJAX] database list not updated after adding/deleting a user + database
  • bug #3461750 [edit] Sort by key generates wrong sql with limit clause
  • bug #3340842 [structure] Error dropping index of non-existing column
  • bug #3093145 [display] Page through rows returned from a view
  • patch #3303195 [interface] Checkbox to have SQL input remain
  • patch #3472899 [export] Fixed CSV escape for the export
  • patch #3475424 [import] Fixed CSV escape for the import

New in phpMyAdmin 3.5.0 Alpha 1 (Jan 7, 2012)

  • 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

New in phpMyAdmin 3.4.9.0 (Dec 22, 2011)

  • bug #3442028 [edit] Inline editing enum fields with null shows no dropdown
  • bug #3442004 [interface] DB suggestion not correct for user with underscore
  • bug #3438420 [core] Magic quotes removed in PHP 5.4
  • bug #3398788 [session] No feedback when result is empty (signon auth_type)
  • bug #3384035 [display] Problems regarding ShowTooltipAliasTB
  • bug #3306875 [edit] Can't rename a database that contains views
  • bug #3452506 [edit] Unable to move tables with triggers
  • bug #3449659 [navi] Fast filter broken with table tree
  • bug #3448485 [GUI] Firefox favicon frameset regression
  • [core] Better compatibility with mysql extension
  • [security] Self-XSS on export options (export server/database/table)
  • [security] Self-XSS in setup (host parameter),

New in phpMyAdmin 3.4.9.0 RC 1 (Dec 15, 2011)

  • bug #3442028 [edit] Inline editing enum fields with null shows no dropdown
  • bug #3442004 [interface] DB suggestion not correct for user with underscore
  • bug #3438420 [core] Magic quotes removed in PHP 5.4
  • bug #3398788 [session] No feedback when result is empty (signon auth_type)
  • bug #3384035 [display] Problems regarding ShowTooltipAliasTB
  • bug #3306875 [edit] Can't rename a database that contains views
  • bug #3452506 [edit] Unable to move tables with triggers
  • bug #3449659 [navi] Fast filter broken with table tree
  • bug #3448485 [GUI] Firefox favicon frameset regression
  • core] Better compatibility with mysql extension
  • security] Self-XSS on export options (export server/database/table), see PMASA-2011-20
  • security] Self-XSS in setup (host parameter), see PMASA-2011-19

New in phpMyAdmin 3.4.8.0 (Dec 2, 2011)

  • bug #3425230 [interface] enum data split at space char (more space to edit)
  • bug #3426840 [interface] ENUM/SET editor can't handle commas in values
  • bug #3427256 [interface] no links to browse/empty views and tables
  • bug #3430377 [interface] Deleted search results remain visible
  • bug #3428627 [import] ODS import ignores memory limits
  • bug #3426836 [interface] Visual column separation
  • bug #3428065 [parser] TRUE not recognized by parser
  • patch #3433770 [config] Make location of php-gettext configurable
  • patch #3430291 [import] Handle conflicts in some open_basedir situations
  • bug #3431427 [display] Dropdown results - setting NULL does not work
  • patch #3428764 [edit] Inline edit on multi-server configuration
  • patch #3437354 [core] Notice: Array to string conversion in PHP 5.4
  • [interface] When ShowTooltipAliasTB is true, VIEW is wrongly shown as the view name in main panel db Structure page
  • bug #3439292 [core] Fail to synchronize column with name of keyword
  • bug #3425156 [interface] Add column after drop
  • [interface] Avoid showing the password in phpinfo()'s output
  • bug #3441572 [GUI] 'newer version of phpMyAdmin' message not shown in IE8
  • bug #3407235 [interface] Entering the key through a lookup window does not reset NULL
  • [security] Self-XSS on database names (Synchronize), see PMASA-2011-18
  • [security] Self-XSS on database names (Operations/rename), see PMASA-2011-18
  • [security] Self-XSS on column type (Create index), see PMASA-2011-18
  • [security] Self-XSS on column type (table Search), see PMASA-2011-18
  • [security] Self-XSS on invalid query (table overview), see PMASA-2011-18

New in phpMyAdmin 3.4.7.1 (Nov 11, 2011)

  • [security] Fixed possible local file inclusion in XML import

New in phpMyAdmin 3.4.7 (Oct 24, 2011)

  • 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
  • core] Allow to set language in URL
  • bug #3425184 [doc] Fix links to PHP documentation
  • bug #3426031 [export] Export to bzip2 is not working

New in phpMyAdmin 3.4.6 (Oct 17, 2011)

  • patch #3404173 InnoDB comment display with tooltips/aliases
  • bug #3404886 [navi] Edit SQL statement after error
  • bug #3403165 [interface] Collation not displayed for long enum fields
  • bug #3399951 [export] Config for export compression not used
  • bug #3400690 [privileges] DB-specific privileges won't submit
  • bug #3410604 [config] Configuration storage incorrect suggested table name
  • bug #3383572 [interface] Cannot execute saved query
  • bug #3411535 [display] Full text button unchecks results display options
  • bug #3411224 [display] Broken binary column when 'Show binary contents' is not set
  • bug #3411633 [core] Call to undefined function PMA_isSuperuser()
  • bug #3413743 [interface] Display options link missing after search
  • bug #3324161 [core] CSP policy causing designer JS buttons to fail
  • bug #3412862 [relation] Relations/constraints are dropped/created on every change
  • bug #3390832 [display] Delete records from last page breaks search
  • bug #3392150 [schema] PMA_User_Schema::processUserChoice() is broken
  • bug #3414744 [core] External link fails in 3.4.5
  • patch #3314626 [display] CharTextareaRows is not respected
  • bug #3417089 [synchronize] Extraneous db choices
  • [security] Fixed local path disclosure vulnerability, see PMASA-2011-15
  • [security] Fixed XSS in setup (host/verbose parameter), see PMASA-2011-16

New in phpMyAdmin 3.4.5 RC 1 (Sep 9, 2011)

  • bug #3375325 [interface] Page list in navigation frame looks odd
  • bug #3313235 [interface] Error div misplaced
  • bug #3374802 [interface] Comment on a column breaks inline editing
  • patch #3383711 [display] Order by a column in a view doesn't work in some cases
  • bug #3386434 [interface] Add missing space to server status
  • core] Remove library PHPExcel, due to license issues
  • export] Remove native Excel export modules (xls and xlsx formats)
  • import] Remove native Excel import modules (xls and xlsx formats)
  • bug #3392920 [edit] BLOB emptied after editing another column
  • security] Fixed XSS in Inline Edit on save action
  • security] Fixed XSS with db/table/column names

New in phpMyAdmin 3.4.4 (Aug 25, 2011)

  • bug #3323060 [parser] SQL parser breaks AJAX requests if query has unclosed quotes
  • bug #3323101 [parser] Invalid escape sequence in SQL parser
  • bug #3348995 [config] $cfg['Export']['asfile'] set to false does not select asText option
  • bug #3340151 [export] Working SQL query exports error page
  • bug #3353649 [interface] "Create an index on X columns" form not validated
  • bug #3350790 [interface] JS error in Table->Structure->Index->Edit
  • bug #3353811 [interface] Info message has "error" class
  • bug #3357837 [interface] TABbing through a NULL field in the inline mode resets NULL
  • remove version number in /setup
  • bug #3367993 [usability] Missing "Generate Password" button
  • bug #3363221 [display] Missing Server Parameter on inline sql query
  • bug #3367986 [navi] Drop field -> lost active table
  • remove misleading comment on the "Rename database" interface
  • bug #3374374 [interface] Fix footnote for inexact count while browsing
  • bug #3372807 [interface] Fix security warning link in setup
  • bug #3374347 [display] Backquotes in normal text on import page
  • bug #3358750 [core] With Suhosin, urls are too long in edit links
  • security] Missing sanitization on the table, column and index names leads to XSS vulnerabilities, see PMASA-2011-13

New in phpMyAdmin 3.4.3.2 (Jul 25, 2011)

  • [security] Fixed XSS vulnerability, see PMASA-2011-9
  • [security] Fixed local file inclusion vulnerability, see PMASA-2011-10
  • [security] Fixed local file inclusion vulnerability and code execution, see PMASA-2011-11
  • [security] Fixed possible session manipulation in swekey authentication, see PMASA-2011-12

New in phpMyAdmin 3.4.3.1 (Jul 4, 2011)

  • [security] Fixed possible session manipulation in swekey authentication, see PMASA-2011-5
  • [security] Fixed possible code injection incase session variables are compromised, see PMASA-2011-6
  • [security] Fixed regexp quoting issue in Synchronize code, see PMASA-2011-7
  • [security] Fixed filtering of a file path, which allowed for directory traversal, see PMASA-2011-8

New in phpMyAdmin 3.4.3 (Jun 27, 2011)

  • bug #3311170 [sync] Missing helper icons in Synchronize
  • patch #3304473 [setup] Redefine a lable that was wrong
  • bug #3304544 [parser] master is not a reserved word
  • bug #3307616 [edit] Inline edit updates multiple duplicate rows
  • patch #3311539 [edit] Inline edit does not escape backslashes
  • bug #3313210 [interface] Columns class sometimes changed for nothing
  • patch #3313326 [interface] Some tooltips do not disappear
  • bug #3315720 [search] Fix search in non unicode tables
  • bug #3315741 [display] Inline query edit broken
  • patch #3317206 [privileges] Generate password option missing on new accounts
  • bug #3317293 [edit] Inline edit places HTML line breaks in edit area
  • bug #3319466 [interface] Inline query edit does not escape special characters
  • minor XSS (require a valid token)

New in phpMyAdmin 3.4.2 (Jun 7, 2011)

  • bug #3301249 [interface] Iconic table operations does not remove inline edit label
  • bug #3303869 [interface] Unnecessary scrolling on Databases page
  • patch #3303813 [setup] Define a label that was missing
  • bug #3305606 [interface] Show all button wraps on privileges page
  • bug #3305517 [config] Config for export compression not used
  • bug #3305883 [interface] Table is dropped regardless of confirmation
  • [auth] Fixed error handling for signon auth method.
  • bug #3276001 [core] Avoid caching of index.php.
  • bug #3306958 [interface] Unnecessary Details slider
  • bug #3308476 [interface] "Show all" not persistent after a sort
  • bug #3308072 [auth] Version disclosure to anonymous visitors
  • bug #3306981 [interface] pmahomme and table statistics

New in phpMyAdmin 3.4.1 (May 21, 2011)

  • bug #3301108 [interface] Synchronize and already configured host
  • bug #3302457 Inline edit and $cfg['PropertiesIconic']
  • Patch #3302313 Show a translated label
  • bug #3300981 [navi] Table filter is case sensitive
  • bug #3285929 [privileges] Revert temporary fix
  • bug #3302872 [synchronize] Synchronize and user name
  • bug #3302733 [core] Some browsers report an insecure https connection
  • security] Make redirector require valid token

New in phpMyAdmin 3.4.0 (May 12, 2011)

  • RFE #2890226 [view] Enable VIEW rename
  • RFE #838637 [privileges] Export a user's privileges
  • core] Updated mootools to fix some glitches with Safari.
  • RFE #2816943 [interface] Add REGEXP ^...$ to select dialog.
  • RFE #2924956 [interface] Add insert ignore option to editing row.
  • RFE #2838080 [interface] Show warning when javascript is disabled.
  • RFE #2823707 [edit] Call UUID function separately to show it in insert.
  • RFE #2420684 [export] Allow export of timestamps in UTC.
  • core] Remove config data from session as it brings chicken-egg problem.
  • core] Cookie path now honors PmaAbsoluteUri.
  • RFE #2393597 [core] phpMyAdmin honors https in PmaAbsoluteUri.
  • RFE #1778337 [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
  • RFE #1721189 [core] Force reload js on code change.
  • RFE #1954161 [interface] Do not display long numbers in server status.
  • RFE #2033616 [edit] Add option to just display insert query.
  • RFE #1435032 [interface] Move SSL status to the end, it is usually empty.
  • RFE #1340812 [interface] Show numbers of columns in table structure.
  • RFE #1186511 [inrerface] Add link to reload navigation frame.
  • RFE #2936156 [auth] Signon authentication forwards error message through session data.
  • RFE #2835109 [interface] Move ^1 to the end of message.
  • RFE #854911 [interface] Grey out non applicable actions in structure
  • interface] Allow to create new table from navigation frame (in light mode).
  • RFE #1025696 [browse] Add direct download of binary fields.
  • browse] Properly display NULL value for BLOB.
  • RFE #1516803 [edit] Allow to set BLOB to/from NULL with ProtectBinary.
  • edit] Do not default to UNHEX when using file upload.
  • RFE #1379201 [core] Add option to configure session_save_path.
  • interface] Provide links to documentation in highlighted SQL.
  • interface] It is now possible to bookmark most pages in JS capable browser.
  • bug #2936482 [core] Fix SSL detection.
  • RFE #2937850 [doc] Add some hints to chk_rel.php for quick setup.
  • RFE #2938579 [interface] Add class to some elements for easier theming.
  • RFE #2937840 [doc] Add some interesting configs to config.sample.inc.php.
  • RFE #2792992 [doc] Added advice to re-login after changing pmadb settings
  • patch #2952353 [interface] Prefill "Copy table to" in tbl_operations.php, thanks to iinl
  • lang] Add English (United Kingdom) translation, thanks to Robert Readman.
  • patch #2948421 [auth] HTTP Basic auth realm name,
  • thanks to Harald Jenny
  • bug #2954916 [interface] Do not insert doc links to not formatted SQL.
  • lang] Chinese Simplified update, thanks to Shanyan Baishui
  • lang] Turkish update, thanks to Burak Yavuz
  • RFE #2963310 [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
  • lang] Uzbek update, thanks to Orzu Samarqandiy
  • RFE #2958013 [import] After import, also list uploaded filename, thanks
  • to Pavel Konnikov and Herman van Rink
  • patch #2974341 [structure] Clicking on table name in db Structure should
  • Browse the table if possible, thanks to bhdouglass
  • patch #2975533 [search] New search operators, thanks to
  • Martynas Mickevicius
  • patch #2967320 [designer] Colored relations based on the primary key,
  • thanks to GreenRover
  • core] Provide way for vendors to easily change paths to config files.
  • patch #2979922, RFE #2804874 [interface] Add inline query editing, thanks to Muhammd Adnan.
  • bug #2966752 [setup] Allow to configure changes tracking in setup script.
  • patch #2981165 [edit] Optionally disable the Type column,
  • thanks to Brian Douglass
  • patch #2984058 [edit] Buttons for quicky creating common SQL queries, thanks
  • to sutharshan.
  • patch #2984337 [interface] Convert loading of export/import to jQuery ready
  • event, thanks to sutharshan.
  • edit] CURRENT_TIMESTAMP is also valid for datetime fields.
  • patch #2985068 [engines] Fix parsing of PBXT status, thanks to Madhura Jayaratne.
  • patch #2986073 [interface] Convert upload progress bar to jQuery, thanks to
  • Philip Frank.
  • patch #2983960 [interface] Add javascript validation of datetime input,
  • thanks to Sutharshan Balachandren.
  • RFE #2981999 [interface] Default sort order is now SMART.
  • RFE #2972969 [interface] Fix flipping of headers in non-IE browsers.
  • RFE #2964518 [interface] Allow to choose servers from configuration for
  • synchronisation.
  • RFE #2988633 [relation] Improve ON DELETE/ON UPDATE drop-downs
  • RFE #2988629 [relation] Improve labels in relation view
  • RFE #2983207, patch #2988715 [interface] Use jQuery calendar dialog, thanks
  • to Muhammad Adnan.
  • doc] Incorporate synchronisation docs into main document.
  • core] Include Content Security Policy HTTP headers.
  • bug #3004216 [CSS] Field attributes use inline CSS
  • patch #2999595, RFE #2998130 [interface] Cleanup navigation frame.
  • patch #3025161 [core] Prevent sending of unnecessary cookies,
  • thanks to Piotr Przybylski
  • bug [password] Generate password only available if JS is enabled
  • fixed for Privileges and Change password)
  • core] RecodingEngine now accepts none as valid option.
  • core] Dropped AllowAnywhereRecoding configuration variable.
  • RFE #3016457 [interface] Define tab order in SQL form to allow easier tab
  • navigation.
  • core] Centralized format string expansion, @VARIABLES@ are recommended way
  • now, used by file name templates, default queries, export and title
  • generating.
  • validator] SQL validator works also with SOAP PHP extension.
  • interface] Better formatting for SQL validator results.
  • doc] The linked-tables infrastructure is now called phpMyAdmin
  • configuration storage.
  • interface] Move drop/empty links from being tabs to Operations tab.
  • interface] Fixed rendering of error/notice/info titles background.
  • patch #3038293 [doc] Language and grammar fixes,
  • thanks to Isaac Bennetch
  • patch #3038312 [export] JSON export,
  • thanks to Hauke Henningsen
  • RFE #1494550 [interface] Editor for SET/ENUM fields.
  • RFE #2649375 [interface] Simplified interface to backup/restore.
  • RFE #2973909 Users preferences
  • relations] Dropped WYSIWYG-PDF configuration variable.
  • RFE #806035, bug #686260 [relations] Export relations to Dia, SVG and others
  • interface] Added charts to status tab, profiling page and query results
  • interface] AJAXification on various pages
  • core] Remove last remaining parts of profiling code which was removed in 2006.
  • bug #3042665 [parser] Add workaround for MySQL way of handling backtick.
  • bug #3056610 [interface] Removed modification options for information_schema
  • patch #3055886 [config] Add Left frame table filter visibility config option, thanks to eesau
  • core] Force generating of new session on login
  • RFE #1105678 [interface] Drop page-break-before as it is useless for smaller
  • tables.
  • RFE #2956556 [interface] Allow to wrap enum values.
  • bug #1669459 [interface] Do not automatically mark PDF schema rows to delete
  • bug #3087682 [interface] Do not apply LeftFrameDBSeparator on first character.
  • RFE #3111455 [interface] Column highlighting and marking in table view
  • Visual query builder
  • bug #3115519 [interface] Prevent long queries from being shown in confirmation
  • popup
  • patch #3112792 [navi] Left panel table grouping incorrect,
  • thanks to garas - garas
  • bug #3123433 [interface] Avoid double escaping of MySQL errors.
  • interface] Use less noisy message and remove disable link on server charts an
  • d database statistics.
  • rfe #3141330 [relation] When displaying results, show a link to the foreign
  • table even when phpMyAdmin configuration storage is not active
  • bug #3141327 [relation] Foreign key input options
  • export] Better handling of export to PHP array.
  • rfe #3158867 [privileges] No DROP DATABASE warning if you delete a user
  • interface] Add link to documentation for status variables.
  • security] Redirect external links to avoid Referer leakage.
  • interface] Default to not count tables in database.
  • patch #3172172 [interface] Shortcut for copying table row.
  • bug #3175227 [auth] Reset user cache on login.
  • rfe #3148361 [interface] Replace hard coded limit with $cfg['LimitChars'].
  • bug #3177136 [interface] Indicate that bookmark is being used on browse.
  • interface] Indicate shared bookmarks in interface.
  • patch #3176420 [Search] Ajaxify browse and delete criteria in DB Search,
  • thanks to Thilanka Kaushalya
  • interface] New default theme pmahomme, dropped darkblue_orange theme.
  • rfe #2936155 [auth] Allow to pass additional parameters using signon method.
  • rfe #1640812 [auth] Add example for OpenID authentication using signon method.
  • rfe #1312657 [dbi] Default to mysqli extension.
  • rfe #1168350 [interface] Add clear button to SQL edit box.
  • core] Update library PHPExcel to version 1.7.6
  • bug #3206876 [core] Work without mbstring installed.
  • rfe #3196075, patch #3212068 [interface] Add links to variables documentation.
  • bug #3208723 [import] Fix import of utf-8 XML files.
  • bug #3039384 [auth] Force signon auth on signon URL change.
  • bug #3168733 [core] Synchronization does not honor AllowArbitraryServer
  • bug #3134495 [synchronization] Data containing single quotes prevents sync,
  • thanks to jviewer
  • Remove the custom color picker feature
  • bug #3285929 [privileges] Don't fail silently on missing priviledge to execute
  • REVOKE ALL PRIVILEGES

New in phpMyAdmin 3.4.0 RC 2 (Apr 27, 2011)

  • This release contains new features, especially:
  • User preferences
  • Relation schema export to multiple formats
  • ENUM/SET editor
  • Simplified interface for export/import
  • AJAXification of some parts
  • Charts
  • Visual query builder

New in phpMyAdmin 3.3.10.0 (Mar 19, 2011)

  • patch #3147400 [structure] Aria table size printed as unknown,
  • patch #3150164 [structure] Ordering by size gives incorrect results,
  • bug #3153409 [core] 0 row(s) affected
  • bug #3155842 [core] Edit relational page and page number
  • [security] Minor security fixes, see PMASA-2010-9 and PMASA-2010-10
  • [lang] German update, thanks to [email protected].

New in phpMyAdmin 3.3.9.2 (Feb 12, 2011)

  • A security release

New in phpMyAdmin 3.3.9.1 (Feb 9, 2011)

  • This is a security release
  • Version compatible with PHP 5 and MySQL 5

New in phpMyAdmin 3.4.0 Beta 2 (Jan 8, 2011)

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

New in phpMyAdmin 3.4.0 Beta 1 (Jan 3, 2011)

  • RFE 2890226 [view] Enable VIEW rename
  • RFE 838637 [privileges] Export a user's privileges
  • [core] Updated mootools to fix some glitches with Safari.
  • RFE 2816943 [interface] Add REGEXP ^...$ to select dialog.
  • RFE 2924956 [interface] Add insert ignore option to editing row.
  • RFE 2838080 [interface] Show warning when javascript is disabled.
  • RFE 2823707 [edit] Call UUID function separately to show it in insert.
  • RFE 2420684 [export] Allow export of timestamps in UTC.
  • [core] Remove config data from session as it brings chicken-egg problem.
  • [core] Cookie path now honors PmaAbsoluteUri.
  • RFE 2393597 [core] phpMyAdmin honors https in PmaAbsoluteUri.
  • RFE 1778337 [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
  • RFE 1721189 [core] Force reload js on code change.
  • RFE 1954161 [interface] Do not display long numbers in server status.
  • RFE 2033616 [edit] Add option to just display insert query.
  • RFE 1435032 [interface] Move SSL status to the end, it is usually empty.
  • RFE 1340812 [interface] Show numbers of columns in table structure.
  • RFE 1186511 [inrerface] Add link to reload navigation frame.
  • RFE 2936156 [auth] Signon authentication forwards error message through session data.
  • RFE 2835109 [interface] Move ^1 to the end of message.
  • RFE 854911 [interface] Grey out non applicable actions in structure
  • [interface] Allow to create new table from navigation frame (in light mode).
  • RFE 1025696 [browse] Add direct download of binary fields.
  • [browse] Properly display NULL value for BLOB.
  • RFE 1516803 [edit] Allow to set BLOB to/from NULL with ProtectBinary.
  • [edit] Do not default to UNHEX when using file upload.
  • RFE 1379201 [core] Add option to configure session_save_path.
  • [interface] Provide links to documentation in highlighted SQL.
  • [interface] It is now possible to bookmark most pages in JS capable browser.
  • bug 2936482 [core] Fix SSL detection.
  • RFE 2937850 [doc] Add some hints to chk_rel.php for quick setup.
  • RFE 2938579 [interface] Add class to some elements for easier theming.
  • RFE 2937840 [doc] Add some interesting configs to config.sample.inc.php.
  • RFE 2792992 [doc] Added advice to re-login after changing pmadb settings
  • patch 2952353 [interface] Prefill "Copy table to" in tbl_operations.php
  • [lang] Add English (United Kingdom) translation.
  • patch 2948421 [auth] HTTP Basic auth realm name
  • bug 2954916 [interface] Do not insert doc links to not formatted SQL.
  • [lang] Chinese Simplified update
  • [lang] Turkish update
  • RFE 2963310 [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
  • [lang] Uzbek update
  • RFE 2958013 [import] After import, also list uploaded filename
  • patch 2974341 [structure] Clicking on table name in db Structure should
  • Browse the table if possible
  • patch 2975533 [search] New search operators
  • patch 2967320 [designer] Colored relations based on the primary key
  • [core] Provide way for vendors to easily change paths to config files.
  • patch 2979922, RFE 2804874 [interface] Add inline query editing
  • bug 2966752 [setup] Allow to configure changes tracking in setup script.
  • patch 2981165 [edit] Optionally disable the Type column
  • patch 2984058 [edit] Buttons for quicky creating common SQL queries
  • patch 2984337 [interface] Convert loading of export/import to jQuery ready
  • event
  • [edit] CURRENT_TIMESTAMP is also valid for datetime fields.
  • patch 2985068 [engines] Fix parsing of PBXT status
  • patch 2986073 [interface] Convert upload progress bar to jQuery
  • patch 2983960 [interface] Add javascript validation of datetime input,
  • thanks to Sutharshan Balachandren.
  • RFE 2981999 [interface] Default sort order is now SMART.
  • RFE 2972969 [interface] Fix flipping of headers in non-IE browsers.
  • RFE 2964518 [interface] Allow to choose servers from configuration for
  • synchronisation.
  • RFE 2988633 [relation] Improve ON DELETE/ON UPDATE drop-downs
  • RFE 2988629 [relation] Improve labels in relation view
  • RFE 2983207, patch 2988715 [interface] Use jQuery calendar dialog
  • [doc] Incorporate synchronisation docs into main document.
  • [core] Include Content Security Policy HTTP headers.
  • bug 3004216 [CSS] Field attributes use inline CSS
  • patch 2999595, RFE 2998130 [interface] Cleanup navigation frame.
  • patch 3025161 [core] Prevent sending of unnecessary cookies,
  • bug [password] Generate password only available if JS is enabled
  • (fixed for Privileges and Change password)
  • [core] RecodingEngine now accepts none as valid option.
  • [core] Dropped AllowAnywhereRecoding configuration variable.
  • RFE 3016457 [interface] Define tab order in SQL form to allow easier tab
  • navigation.
  • [core] Centralized format string expansion, @VARIABLES@ are recommended way now, used by file name templates, default queries, export and title
  • generating.
  • [validator] SQL validator works also with SOAP PHP extension.
  • [interface] Better formatting for SQL validator results.
  • [doc] The linked-tables infrastructure is now called phpMyAdmin
  • configuration storage.
  • [interface] Move drop/empty links from being tabs to Operations tab.
  • [interface] Fixed rendering of error/notice/info titles background.
  • patch 3038293 [doc] Language and grammar fixes
  • patch 3038312 [export] JSON export
  • RFE 1494550 [interface] Editor for SET/ENUM fields.
  • RFE 2649375 [interface] Simplified interface to backup/restore.
  • RFE 2973909 Users preferences
  • [relations] Dropped WYSIWYG-PDF configuration variable.
  • RFE 806035, bug 686260 [relations] Export relations to Dia, SVG and others
  • [interface] Added charts to status tab, profiling page and query results
  • [interface] AJAXification on various pages
  • [core] Remove last remaining parts of profiling code which was removed in 2006.
  • bug 3042665 [parser] Add workaround for MySQL way of handling backtick.
  • bug 3056610 [interface] Removed modification options for information_schema
  • patch 3055886 [config] Add Left frame table filter visibility config option
  • [core] Force generating of new session on login
  • RFE 1105678 [interface] Drop page-break-before as it is useless for smaller
  • tables.
  • RFE 2956556 [interface] Allow to wrap enum values.
  • bug 1669459 [interface] Do not automatically mark PDF schema rows to delete
  • bug 3087682 [interface] Do not apply LeftFrameDBSeparator on first character.
  • RFE 3111455 [interface] Column highlighting and marking in table view
  • Visual query builder
  • bug 3115519 [interface] Prevent long queries from being shown in confirmation popup
  • patch 3112792 [navi] Left panel table grouping incorrect,
  • thanks to garas - garas
  • bug 3123433 [interface] Avoid double escaping of MySQL errors.

New in phpMyAdmin 3.3.9 (Jan 3, 2011)

  • bug [doc] Fix references to MySQL doc
  • patch #3101490 Default function for TIMESTAMP, thanks to jirand - jirand
  • bug #3103853 [js] Double quotes were not escaped in generated js
  • bug #3077463 [core] Events were not copied when copying/renaming database
  • bug #1762306 [core] Copy database with view of a view
  • patch #3117535 [replication] Add quotes to database in initial statement,
  • bug #3112614 [pdf schema] Scratchboard for PDF pages not working
  • bug #3125606 [parser] Query for table "level" causes strange display
  • bug #3127904 [parser] Close all opened round brackets indents

New in phpMyAdmin 3.3.8.1 (Nov 30, 2010)

  • A security release

New in phpMyAdmin 3.3.8 (Oct 25, 2010)

  • bug #3059311 [import] BIGINT field type added to table analysis
  • [core] Update library PHPExcel to version 1.7.4
  • bug #3062455 [core] copy procedures and routines before tables
  • bug #3062455 [export] with SQL, export procedures and routines before tables
  • bug #3056023 [import] USE query not working
  • bug #3038193 [display] Error when editing row with GEOMETRY column
  • bug #3062454 [interface] Display routines/events also when no tables are defin
  • support ARIA storage engine as well as its previous name MARIA

New in phpMyAdmin 3.3.8 RC 1 (Oct 18, 2010)

  • bug #3059311 [import] BIGINT field type added to table analysis
  • [core] Update library PHPExcel to version 1.7.4
  • bug #3062455 [core] copy procedures and routines before tables
  • bug #3062455 [export] with SQL, export procedures and routines before tables
  • bug #3056023 [import] USE query not working
  • bug #3038193 [display] Error when editing row with GEOMETRY column
  • bug #3062454 [interface] Display routines/events also when no tables are defin
  • support ARIA storage engine as well as its previous name MARIA

New in phpMyAdmin 3.3.7 (Sep 7, 2010)

  • patch #3050492 [PDF scratchboard] Cannot drag table box to the edge after
  • a page size increase, thanks to Martin Schönberger - mad05
  • bug #3054458 [core] Fixed displaying number of rows.
  • bug #3035300 [parser] Fixed wrong definition of keywords.
  • [setup] Fixed escaping of server name.

New in phpMyAdmin 3.3.7.1 RC 1 (Sep 1, 2010)

  • patch #3050492 [PDF scratchboard] Cannot drag table box to the edge after
  • a page size increase, thanks to Martin Schönberger - mad05
  • bug #3054458 [core] Fixed displaying number of rows.
  • bug #3035300 [parser] Fixed wrong definition of keywords.
  • [setup] Fixed escaping of server name.

New in phpMyAdmin 3.3.6.0 (Aug 29, 2010)

  • bug #3033063 [core] Navi gets wrong db name
  • bug #3031705 [core] Fix generating condition for real numbers by comparing
  • them to string.
  • bug #3034026 [confirmation] TRUNCATE queries get no confirmation request
  • bug #3036132 [core] Triggers not fetched if dbname has an hyphen
  • patch #3039269 [dbi] Wrong variable checked for nopassword option,
  • thanks to Will Palmer - wpalmer
  • bug #3040226 [XHTML] LockFromUpdate checkbox not checked by default
  • bug [doc] Withdraw or edit FAQ entries related to older MySQL or PHP
  • bug #3042706 [pmadb] Relations, bookmarks, etc deleted after table drop
  • bug #3044189 [doc] Cleared documentation for hide_db.
  • bug #3042495 [core] Move PMA_sendHeaderLocation to core.lib.php.

New in phpMyAdmin 3.3.6.0 RC1 (Aug 21, 2010)

  • bug #3033063 [core] Navi gets wrong db name
  • bug #3031705 [core] Fix generating condition for real numbers by comparing them to string.
  • bug #3034026 [confirmation] TRUNCATE queries get no confirmation request
  • bug #3036132 [core] Triggers not fetched if dbname has an hyphen
  • patch #3039269 [dbi] Wrong variable checked for nopassword option, thanks to Will Palmer - wpalmer
  • bug #3040226 [XHTML] LockFromUpdate checkbox not checked by default
  • bug [doc] Withdraw or edit FAQ entries related to older MySQL or PHP
  • bug #3042706 [pmadb] Relations, bookmarks, etc deleted after table drop
  • bug #3044189 [doc] Cleared documentation for hide_db.
  • bug #3042495 [core] Move PMA_sendHeaderLocation to core.lib.php.

New in phpMyAdmin 3.3.5.1 (Aug 20, 2010)

  • [core] Fixed various XSS issues, see PMASA-2010-5 for more details.

New in phpMyAdmin 3.3.5 (Jul 27, 2010)

  • patch #2932113 [information_schema] Slow export when having lots of databases, thanks to Stéphane Pontier - shadow_walker
  • bug #3022705 [import] Import button does not work in Catalan when there is no progress bar possible
  • bug [replication] Do not offer information_schema in the list of databases
  • bug [js] Avoid loading twice a js file
  • bug #3024344 [setup] Setup forces numeric MemoryLimit
  • bug #3025975 [auth] Odd LoginCookieValidity default value
  • bug #3026400 [PHP] ereg functions are deprecated
  • bug #3027557 [PHP] split() deprecated in PHP 5.3 (backport fixes from master)
  • bug #3023507 [core] No result set display from stored procedure SELECT
  • bug [export] CSV for MS Excel (Windows) should have semi-colon as separator
  • [core] Update library PHPExcel to version 1.7.3c
  • bug #2994885, bug #3029168 [import] Convert Excel column name correctly
  • bug [scripts] MySQL 5.5.5 does not accept TIMESTAMP(14) in create_tables.sql

New in phpMyAdmin 3.3.4 (Jun 28, 2010)

  • bug #2996161 [import] properly escape import value
  • bug #2998889 [import] Import button does not work in Catalan
  • browse] Fix handling of sort order if only column is specified.
  • lang] Greek update, thanks to Panagiotis Papazoglou - panos78
  • lang] Updated lot of translation based on work done in master branch.
  • bug #3008411 [databases] Last dropped database remains active in navi
  • bug #2986383 [parser] Not all data being shown / counted
  • bug [synchronize] Rows were deleted in target table regardless of the
  • "Would you like to delete..." option
  • bug [privileges] List of tables not shown when the db name has a wildcard
  • bug #3011126 [display] Edit link missing after long query
  • patch #3013264 [doc] FAQ 1.40 uses a comma instead of a period,
  • thanks to Isaac Bennetch - ibennetch
  • engines] Fix getting InnoDB status.
  • bug #2986422 [import] Results for query are not displayed

New in phpMyAdmin 3.3.3 (May 11, 2010)

  • patch #2982480 [navi] Do not group if there would be one table in group
  • patch #2983492 [sync] When asking to synchronize Structure and Data,
  • only Structure is done
  • patch #2984893 [engines] InnoDB storage page emits a warning
  • bug #2974687, bug #2974692 [compatibility] PHPExcel : IBM AIX iconv() does not work
  • bug #2983066 [interface] Flush table on table operations shows the query twice
  • bug #2983060, patch #2987900 [interface] Fix initial state of tables in
  • designer
  • bug #2983062, patch #2989408 [engines] Fix warnings when changing table
  • engine to Maria
  • bug #2974067 [display] non-binary fields shown as hex
  • bug #2983065 [operations] Error when changing from Maria to MyISAM engine
  • bug #2975408 [tracking] Data too long for column data_sql
  • bug [tracking] Tracking report should obey MaxCharactersInDisplayedSQL
  • bug [edit] Avoid selecting UNHEX function by default for a BLOB column for
  • which editing is protected
  • bug #2994168 [structure] Show auto_increment in uppercase
  • bug #2993970 [pdf schema] Page numbering in Table of Contents

New in phpMyAdmin 3.3.2 (Apr 14, 2010)

  • patch #2969449 [core] Name for MERGE engine varies depending on the MySQL version, thanks to Dieter Adriaenssens - ruleant
  • bug #2966078 [browse] Incorrect LIMIT is saved and sticks while browsing
  • bug #2967366 [Structure] Some results of Propose table structure are shown in hex
  • bug #2967565 [insert] UNHEX not selected by default when inserting BINARY
  • [navi] Changed link to git repository on main page
  • bug #2972232 [menu] Import menu tab not present on main page
  • patch #2976790 [menu] Go to the upper level after table DROP, thanks to Kaarel Nummert - kaarelnu
  • patch #2978815 [pdf] Fix generating PDF with table dimensions, thanks to BlinK_
  • patch #2977725 [export] XML wrongly encoded, thanks to Victor Volkov - hanut
  • patch #2979234 [import] Create tables with current charset and collation.
  • patch #2979234, bug #2960105 [import] Properly import unicode text from ODS.
  • bug #2973280 [export] Proper handling of temporary directory in XLS export.
  • bug #2980582 [interface] Properly format server status parameter.
  • bug #2973949 [session] SQL History broken (revert patch #2899969),
  • thanks to Dieter Adriaenssens - ruleant
  • [doc] Be more specific about problems with Suhosin.

New in phpMyAdmin 3.3.2 RC 1 (Apr 7, 2010)

  • patch #2969449 [core] Name for MERGE engine varies depending on the MySQL version, thanks to Dieter Adriaenssens - ruleant
  • bug #2966078 [browse] Incorrect LIMIT is saved and sticks while browsing
  • bug #2967366 [Structure] Some results of Propose table structure are shown in hex
  • bug #2967565 [insert] UNHEX not selected by default when inserting BINARY
  • [navi] Changed link to git repository on main page
  • bug #2972232 [menu] Import menu tab not present on main page
  • patch #2976790 [menu] Go to the upper level after table DROP, thanks to Kaarel Nummert - kaarelnu
  • patch #2978815 [pdf] Fix generating PDF with table dimensions, thanks to BlinK_
  • patch #2977725 [export] XML wrongly encoded, thanks to Victor Volkov - hanut
  • patch #2979234 [import] Create tables with current charset and collation.
  • patch #2979234, bug #2960105 [import] Properly import unicode text from ODS.
  • bug #2973280 [export] Proper handling of temporary directory in XLS export.
  • bug #2980582 [interface] Properly format server status parameter.
  • bug #2973949 [session] SQL History broken (revert patch #2899969), thanks to Dieter Adriaenssens - ruleant

New in phpMyAdmin 3.3.1 (Mar 16, 2010)

  • bug #2941037 [core] Database structure not sorted by table correctly
  • bug #2948492 [interface] Slide effect masks some fields on search page
  • bug #2959746 [interface] Unknown table status: TABLE_TYPE
  • bug #2953050 [export] export VIEW as SQL includes INSERT statement
  • bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
  • bug #2961609 [auth] Potential information disclosure at login page
  • patch #2961540 [export] Do not export data of MERGE table,
  • thanks to Dieter Adriaenssens - ruleant
  • bug #2961198 [parser] Querying a table named "data"
  • bug #2931429 [structure] Editing long triggers
  • bug #2970769 [structure] Incorrect reference to mootools-more.js

New in phpMyAdmin 3.3.1 RC1 (Mar 11, 2010)

  • bug #2941037 [core] Database structure not sorted by table correctly
  • bug #2948492 [interface] Slide effect masks some fields on search page
  • bug #2959746 [interface] Unknown table status: TABLE_TYPE
  • bug #2953050 [export] export VIEW as SQL includes INSERT statement
  • bug #2942032 [core] Cannot detect PmaAbsoluteUri correctly on Windows
  • bug #2961609 [auth] Potential information disclosure at login page
  • patch #2961540 [export] Do not export data of MERGE table
  • bug #2961198 [parser] Querying a table named "data"
  • bug #2931429 [structure] Editing long triggers

New in phpMyAdmin 3.3.0 (Mar 8, 2010)

  • rfe #2308632 [edit] Use hex for (var)binary fields
  • patch #2794819 [navi] Filter for displayed table names
  • bug #2794840 [core] Cannot redeclare pma_tableheader()
  • rfe #2726479 [core] configurable maximal length of URL
  • patch #2724755 [display] Full/partial text links (big T) are back
  • bug [display] handle NavigationBarIconic as documented for navi buttons
  • rfe #2726479 [export] Export tables preselect
  • patch #2805828 [export] PHP array export plugin
  • patch #2798592 [import] Progress bar
  • bug [gui] Generate Password not working for 'Change Login Information', only for 'Change password'
  • [lang] Arabic update
  • rfe #2822190 [structure] BOOLEAN is standard SQL
  • [lang] German update
  • rfe #2813867 [structure] Default sorting order in list of tables
  • [import] Added MySQL type-detection functionality to import library
  • [import] Added ODS, Excel XLS, Excel XLSX, and XML import modules
  • [export] Added Excel XLSX export module
  • [core] Added ability for tracking changes made through phpMyAdmin
  • rfe #2839504 [engines] Support InnoDB plugin's new row formats
  • [core] Added ability for synchronizing databases among servers.
  • [lang] #2843101 Dutch update
  • [lang] Galician update
  • [export] Added MediaWiki export module
  • [lang] Turkish update
  • [auth] Add custom port configuration in signon
  • [core] Removed context from the error handler
  • bug #2883633 [export] Export of InnoDB table is incomplete
  • rfe #2862575 [status] Order query statistics by % desc, skip rows with 0
  • rfe #2823686 [interface] Increase default height of query window
  • rfe #2129902 [structure] Don't hide indexes
  • patch #2812070 [interface] Allow selecting a range of rows by holding shift
  • [lang] Russian update, thanks to Victor Volkov
  • [lang] Greek update, thanks to Panagiotis Papazoglou
  • [lang] Norwegian update, thanks to Sven-Erik Andersen
  • bug #2929958 [import] Cannot import (French interface)
  • [security] Use X-Frame-Options header to protect against ClickJacking.
  • [lang] Finnish update, thanks to Jouni Kahkonen
  • [lang] Lithuanian update, thanks to Rytis Slatkevicius - rytis_s
  • bug #2931939 [status] Seeing "m" as unit is confusing
  • bug #2926613 [edit] Copy database shows errors when DB has foreign key
  • [lang] Catalan update, thanks to Xavier Navarro

New in phpMyAdmin 3.3.0 RC2 (Mar 4, 2010)

  • rfe #2308632 [edit] Use hex for (var)binary fields
  • patch #2794819 [navi] Filter for displayed table names
  • bug #2794840 [core] Cannot redeclare pma_tableheader()
  • rfe #2726479 [core] configurable maximal length of URL
  • patch #2724755 [display] Full/partial text links (big T) are back
  • bug [display] handle NavigationBarIconic as documented for navi buttons
  • rfe #2726479 [export] Export tables preselect
  • patch #2805828 [export] PHP array export plugin
  • patch #2798592 [import] Progress bar
  • bug [gui] Generate Password not working for 'Change Login Information', only for 'Change password'
  • [lang] Arabic update
  • rfe #2822190 [structure] BOOLEAN is standard SQL
  • [lang] German update
  • rfe #2813867 [structure] Default sorting order in list of tables
  • [import] Added MySQL type-detection functionality to import library
  • [import] Added ODS, Excel XLS, Excel XLSX, and XML import modules
  • [export] Added Excel XLSX export module
  • [core] Added ability for tracking changes made through phpMyAdmin
  • rfe #2839504 [engines] Support InnoDB plugin's new row formats
  • [core] Added ability for synchronizing databases among servers.
  • [lang] #2843101 Dutch update
  • [lang] Galician update
  • [export] Added MediaWiki export module
  • [lang] Turkish update
  • [auth] Add custom port configuration in signon
  • [core] Removed context from the error handler
  • bug #2883633 [export] Export of InnoDB table is incomplete
  • rfe #2862575 [status] Order query statistics by % desc, skip rows with 0
  • rfe #2823686 [interface] Increase default height of query window
  • rfe #2129902 [structure] Don't hide indexes
  • patch #2812070 [interface] Allow selecting a range of rows by holding shift
  • [lang] Russian update, thanks to Victor Volkov
  • [lang] Greek update, thanks to Panagiotis Papazoglou
  • [lang] Norwegian update, thanks to Sven-Erik Andersen
  • bug #2929958 [import] Cannot import (French interface)
  • [security] Use X-Frame-Options header to protect against ClickJacking.
  • [lang] Finnish update, thanks to Jouni Kahkonen
  • [lang] Lithuanian update, thanks to Rytis Slatkevicius - rytis_s
  • bug #2931939 [status] Seeing "m" as unit is confusing
  • bug #2926613 [edit] Copy database shows errors when DB has foreign key
  • [lang] Catalan update, thanks to Xavier Navarro

New in phpMyAdmin 3.3.0 RC1 (Feb 12, 2010)

  • new import and export modules
  • changes tracking
  • synchronizing structure and data between servers
  • replication support

New in phpMyAdmin 3.2.4 (Dec 3, 2009)

  • bug [engines] Innodb_buffer_pool_pages_latched no longer returned in status
  • bug #2890451 [setup] Inconsistent generated "designer_coords"
  • bug #2890443 [mysqli] "No index used in query" exception is reported
  • bug #2891250 [ob] Garbled data in navi frame (PHP 5.2.11 bug)
  • bug #2887357 [core] Slow loading times with large databases (partial fix)
  • bug #2893931 [lang] Typo and empty message
  • lang] Russian update
  • bug #2823599 [edit] UUID Primary Key wrongly updated
  • bug #2895894 [structure] Empty default value not set properly
  • bug #2897536 [parser] Copying table with bit field with default
  • bug #2893221 [core] Statement may not be safe to log in statement format

New in phpMyAdmin 3.2.4 RC1 (Nov 24, 2009)

  • a bugfix version.

New in phpMyAdmin 3.2.3 (Oct 31, 2009)

  • patch #2856664 [export] Date, time, and datetime column types now export correctly to OpenOffice Spreadsheet
  • patch #2859788 [parser] Double-character delimiters (bug #2846239)
  • bug #2832600 [export] Slow export when having lots of databases
  • bug #2537766 [import] Comments are stripped when editing store procedures
  • bug #2852370 [operations] Renaming database deletes triggers
  • bug #2872247 [interface] Failed opening required 'mysql_charsets.lib.php'
  • bug [structure] "In use" table incorrectly reported as "view"
  • bug #2879909 [interface] Removed double htmlspecialchars when editing enum column
  • bug #2868328 [relations] Adding foreign key when table name contains a dot
  • bug #2883381 [doc] Side effects of MemoryLimit setting
  • bug #2826128 [display] Inverting sort order when expression contains a function name

New in phpMyAdmin 3.2.2.1 (Oct 13, 2009)

  • [security] XSS and SQL injection, thanks to Herman van Rink

New in phpMyAdmin 3.2.2 (Sep 14, 2009)

  • bug #2825293 [structure] Default value for a BIT column
  • bug [display] Red arrows were reversed in the list of tables
  • bug #2813879 [export] Duplicate empty lines when exporting without comments
  • bug #2825919 [export] Trigger export with database name
  • bug #2823996 [data] Cannot edit row with no PK and a BIT field
  • bug [export] Exporting results of a query which contains a LIMIT clause
  • inside a subquery
  • bug #2837722 [export] Run complex SQL then export does not work
  • bug #2839548 [export] Triggers order on export
  • bug #2826986 [display] Order by BLOB and range display
  • bug [display] After clicking on Show Function or Function, the UPDATE query
  • is not shown after execution
  • bug [structure] Missing validation for BINARY and VARBINARY

New in phpMyAdmin 3.2.2.0 RC / 3.2.1 (Sep 6, 2009)

  • bug #2825293 [structure] Default value for a BIT column
  • bug [display] Red arrows were reversed in the list of tables
  • bug #2813879 [export] Duplicate empty lines when exporting without comments
  • bug #2825919 [export] Trigger export with database name
  • bug #2823996 [data] Cannot edit row with no PK and a BIT field
  • bug [export] Exporting results of a query which contains a LIMIT clause
  • inside a subquery
  • bug #2837722 [export] Run complex SQL then export does not work
  • bug #2839548 [export] Triggers order on export
  • bug #2826986 [display] Order by BLOB and range display
  • bug [display] After clicking on Show Function or Function, the UPDATE query
  • is not shown after execution
  • bug [structure] Missing validation for BINARY and VARBINARY

New in phpMyAdmin 3.2.1 (Sep 6, 2009)

  • a bugfix-only version

New in phpMyAdmin 3.2.1 RC1 (Jul 21, 2009)

  • A bugfix-only version

New in phpMyAdmin 3.2.0.1 (Jun 30, 2009)

  • [security] XSS: Insufficient output sanitizing in bookmarks

New in phpMyAdmin 3.2.0 (Jun 15, 2009)

  • [core] better support for vendor customisation (based on what Debian needs)
  • rfe #2127987 warn when session.gc_maxlifetime is less than cookie validity
  • rfe #2100910 configurable default charset for import
  • rfe #1913541 link to InnoDB status when error 1005 occurs
  • rfe #1927189 strip ` from column names on import
  • rfe #1821619 LeftFrameDBSeparator can be an array
  • patch #1821619 [privileges] Extra back reference when editing table-specific privileges
  • patch #2356575 [display] Sortable database columns
  • patch #2486825 [lang] Wrong string in setup script hints
  • patch #2498350 [cleanup] XHTML cleanup,
  • patch #2494192 [display] Possibility of disabling the sliders
  • patch #2506831 [privileges] Create user for existing database
  • patch #2505255 [privileges] Cleanup
  • bug #2414056 [auth] AllowNoPasswordRoot error message is too vague
  • patch #2596230 [XHTML] View table headers/footers completely
  • patch #2602633 [core] support column name having square brackets
  • [lang] Lithuanian update
  • [auth] New setting AllowNoPassword (supercedes AllowNoPasswordRoot) that applies to all accounts (even the anonymous user)
  • patch #2652972 [relation] Missing code with hashing for relationship editing
  • rfe #2123386 Added option to disable mcrypt warning.
  • bug #2648502 Request-URI Too Large error from Location header
  • rfe #1731967 Check for relations support on main page.
  • rfe #2186820 Explanation for using Host table.
  • rfe #1369509 Link to download more themes.
  • rfe #1666487 Add option to generate password on change password page.
  • rfe #1694104 Allow logging of user status with Apache.
  • patch #2649087 None default is different than other None in some languages.
  • [lang] Chinese Simplified update
  • patch #2550286 [display] Sort arrows problem
  • [security] warn about existence of config directory on main page
  • patch #2706761 [lang] Polish update
  • patch #2715142 [export] (rfe 2416960, escape new line in CSV export)
  • patch #2727250 Optimizations for PHP loops
  • bug #2650776 [import] SQL_MODE not saved during Partial Import
  • patch #1863739 [auth] cache control missing (PHP-CGI)
  • patch #2750541 [parser] Incorrect parsing of constraints in ALTER TABLE
  • patch #2735162 [status] Server status - replication
  • patch #2745215 [edit] Multi-row change with "]" improved
  • rfe #2657696 Automatically copy generated password
  • bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
  • patch #2665440 Detect mcrypt initialization failure
  • [lang] Galician update
  • [lang] Swedish update
  • [lang] Norwegian update
  • [lang] Catalan update
  • [lang] Finnish update
  • [lang] Hungarian update

New in phpMyAdmin 3.2.0 RC1 (May 31, 2009)

  • This version contains a number of small new features and some bug fixes.

New in phpMyAdmin 3.2.0 Beta 1 (May 20, 2009)

  • [core] better support for vendor customisation (based on what Debian needs)
  • rfe #2127987 warn when session.gc_maxlifetime is less than cookie validity
  • rfe #2100910 configurable default charset for import
  • rfe #1913541 link to InnoDB status when error 1005 occurs
  • rfe #1927189 strip ` from column names on import
  • rfe #1821619 LeftFrameDBSeparator can be an array
  • patch #1821619 [privileges] Extra back reference when editing table-specific privileges
  • patch #2356575 [display] Sortable database columns
  • patch #2486825 [lang] Wrong string in setup script hints
  • patch #2498350 [cleanup] XHTML cleanup,
  • patch #2494192 [display] Possibility of disabling the sliders
  • patch #2506831 [privileges] Create user for existing database
  • patch #2505255 [privileges] Cleanup
  • bug #2414056 [auth] AllowNoPasswordRoot error message is too vague
  • patch #2596230 [XHTML] View table headers/footers completely
  • patch #2602633 [core] support column name having square brackets
  • [lang] Lithuanian update
  • [auth] New setting AllowNoPassword (supercedes AllowNoPasswordRoot) that applies to all accounts (even the anonymous user)
  • patch #2652972 [relation] Missing code with hashing for relationship editing
  • rfe #2123386 Added option to disable mcrypt warning.
  • bug #2648502 Request-URI Too Large error from Location header
  • rfe #1731967 Check for relations support on main page.
  • rfe #2186820 Explanation for using Host table.
  • rfe #1369509 Link to download more themes.
  • rfe #1666487 Add option to generate password on change password page.
  • rfe #1694104 Allow logging of user status with Apache.
  • patch #2649087 None default is different than other None in some languages.
  • [lang] Chinese Simplified update
  • patch #2550286 [display] Sort arrows problem
  • [security] warn about existence of config directory on main page
  • patch #2706761 [lang] Polish update
  • patch #2715142 [export] (rfe 2416960, escape new line in CSV export)
  • patch #2727250 Optimizations for PHP loops
  • bug #2650776 [import] SQL_MODE not saved during Partial Import
  • patch #1863739 [auth] cache control missing (PHP-CGI)
  • patch #2750541 [parser] Incorrect parsing of constraints in ALTER TABLE
  • patch #2735162 [status] Server status - replication
  • patch #2745215 [edit] Multi-row change with "]" improved
  • rfe #2657696 Automatically copy generated password
  • bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
  • patch #2665440 Detect mcrypt initialization failure
  • [lang] Galician update
  • [lang] Swedish update

New in phpMyAdmin 3.1.5 (May 16, 2009)

  • patch #2739001 [export] XML does not allow spaces in element names
  • bug #2780722 [import] Incorrect maximum file size
  • bug #2780356 [calendar] Null checkbox not unchecked when date is chosen
  • bug [calendar] js error "window.parent.addEvent is not a function"
  • patch #2773818 [export] Invalid "Content-Encoding" header
  • bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
  • bug #2784400 [parser] INVOKER not understood by parser
  • [core] Compatibility with PHP 5.3.0RC2

New in phpMyAdmin 3.1.5 RC1 (May 8, 2009)

  • patch #2739001 [export] XML does not allow spaces in element names
  • bug #2780722 [import] Incorrect maximum file size
  • bug #2780356 [calendar] Null checkbox not unchecked when date is chosen
  • bug [calendar] js error "window.parent.addEvent is not a function"
  • patch #2773818 [export] Invalid "Content-Encoding" header
  • bug #2787162 [interface] Table with name 'log_views' is incorrectly displayed as a view
  • bug #2784400 [parser] INVOKER not understood by parser
  • [core] Compatibility with PHP 5.3.0RC2

New in phpMyAdmin 3.1.4 (Apr 25, 2009)

  • patch #1808339 [doc] Apache SSLOptions and StdEnvVars FAQ
  • bug #2491017 [operations] ANSI mode not supported (db rename and table move)
  • bug #2609346 [operations] Fix copying views.
  • rfe #2127983 Readd documentation link, it does not protect against anything.
  • bug #1675249 [doc] Apache reverse proxy and cookies FAQ
  • bug #2682140 UUID() and CURRENT_USER() should not accept arguments
  • patch #2682833 [core] Fatal error: Call to a member function isDisplayed()
  • patch #2702772 [lang] Duplicate sentence in Polish
  • patch #2709040 [doc] Wrong link in ChangeLog formatter
  • patch #2715417 [interface] Fixed truncation of enum/set values containing parenthesis
  • [lang] Spanish update
  • bug #2724844 Add Fields: Add index is missing quotes
  • bug #2740550 [interface] Using textarea CharEditing drops default values
  • bug #2729191 [config] CheckConfigurationPermissions = false is worthless
  • bug #2687046 [export] Structure export: Null always YES
  • [doc] typos

New in phpMyAdmin 3.1.3.1 (Mar 24, 2009)

  • [security] HTTP Response Splitting and file inclusion vulnerabilities - [security] XSS vulnerability on export page
  • [security] Insufficient output sanitizing when generating configuration file

New in phpMyAdmin 3.1.3.0 (Mar 1, 2009)

  • [lang] Turkish update
  • patch #2496403 [display] Multi-row change with "]"
  • bug #2027720 [parser] Missing space after BINARY used as cast
  • patch #2520747 [core] E_DEPRECATED compatibility for PHP 5.3
  • bug [display] Message "Bookmark created" is not displaying
  • [display] Show AUTO_INCREMENT instead of A_I when in vertical mode
  • patch #2538358 [display] Conditions for relational display field
  • [lang] Mongolian update
  • patch #2553372 [display] DB comment tooltips not shown on navi
  • patch #2561433 [structure] Display true number of rows in a view if it contains less than MaxExactCountViews
  • [lang] Polish update
  • bug #2568722 [designer] Compound key not shown
  • patch #2550323 [XHTML] in server_databases.php
  • patch #2358861 [navi] Row count tooltip wrong for information_schema
  • bug #2565948 [core] Changing the connection collation changed the client charset.
  • [lang] Romanian update
  • patch #1760205 [data] Insert as new row: BLOB is lost
  • [lang] Georgian update

New in phpMyAdmin 3.1.2 (Jan 19, 2009)

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

New in phpMyAdmin 3.1.1 (Dec 10, 2008)

  • patch #2242765 [core] Navi panel server links wrong
  • bug #2186823 [core] bad session.save_path not detected
  • bug #2202709 [core] Re-login causes PMA to forget current table name
  • bug #2280904 [export] do not include view name in export
  • rfe #1688975 [display] enable copying of auto increment by default
  • bug #2355753 [core] do not bail out creating session on any PHP warning
  • bug #2355925 [display] properly update tooltips in navigation frame
  • bug #2355923 [core] do not use ctype if it is not available
  • bug #2356433 [display] HeaderFlipType "fake" problems
  • bug #2363919 [display] Incorrect size for view
  • bug #2121287 [display] Drop-down menu blinking in FF
  • [lang] Catalan update
  • [lang] Finnish update
  • [core] Avoid error with BLOBstreaming support requiring SUPER privilege
  • [security] possible XSRF on several pages

New in phpMyAdmin 3.1.1 RC1 (Dec 7, 2008)

  • a bugfix-only version

New in phpMyAdmin 3.1.0 (Nov 28, 2008)

  • [auth] Support for Swekey hardware authentication,
  • see http://phpmyadmin.net/auth_key
  • bug #2046883 [core] Notices about deprecated dl() (so stop using it)
  • BLOBstreaming support
  • patch #2067462 [lang] link FAQ references in messages
  • new setup script
  • rfe #1892243 [export] more links to documentation
  • [auth] cookie auth now autogenerates blowfish_secret, but it has some
  • limitations and you still should set it in config file
  • [auth] cookie authentication is now the default
  • [auth] do not allow root user without password unless explicitly enabled by
  • AllowNoPasswordRoot
  • rfe #1778908 [auth] arbitrary server auth can now also accept port
  • patch #2089240 [export] handle correctly switching SQL modes
  • rfe #1612724 [export] add option to export without comments
  • bug #2090002 [display] Cannot edit row in VIEW
  • patch #2099962 [js] fix js error without frameset
  • patch #2099972 [structure] Display None when there is no default value
  • patch #2122883 [PDF schema] Option to display just the keys
  • rfe #1276463 [search] Search empty/not empty values
  • rfe #823652 [structure] ENUM values: field size too small
  • [lang] Persian update
  • [lang] Czech update
  • patch #2255890 [lang] English-language cleanup
  • [lang] Norwegian update
  • [lang] Hungarian update
  • [lang] French update
  • bug #2222344 [display] Query involving a function shown as binary
  • [lang] Italian update
  • [lang] Swedish update
  • bug #2315549 [import] fclose() error with "Create PHP code"
  • [lang] Polish update

New in phpMyAdmin 3.1.0 Beta 1 / 3.0.1.1 (Nov 9, 2008)

  • Improvements for 3.1.0:
  • [auth] Support for Swekey hardware authentication
  • BLOBstreaming support
  • new setup script
  • patch #2067462 [lang] link FAQ references in messages
  • [auth] cookie auth now autogenerates blowfish_secret, but it has
  • some limitations and you still should set it in config file
  • [auth] cookie authentication is now the default
  • [auth] do not allow root user without password unless explicitly
  • enabled by AllowNoPasswordRoot
  • rfe #1892243 [export] more links to documentation
  • rfe #1778908 [auth] arbitrary server auth can now also accept port
  • rfe #1612724 [export] add option to export without comments
  • rfe #1276463 [search] Search empty/not empty values
  • rfe #823652 [structure] ENUM values: field size too small
  • Fixes for 3.1.0:
  • bug #2046883 [core] Notices about deprecated dl() (so stop using it)
  • patch #2089240 [export] handle correctly switching SQL modes
  • bug #2090002 [display] Cannot edit row in VIEW
  • patch #2099962 [js] fix js error without frameset
  • patch #2099972 [structure] Display None when there is no
  • default value
  • patch #2122883 [PDF schema] Option to display just the keys
  • [lang] Persian update
  • [lang] Czech update

New in phpMyAdmin 3.0.1.1 (Oct 31, 2008)

  • bug #2134126 [GUI] SQL error after sorting a subset
  • [lang] Catalan update
  • [lang] Russian update
  • patch #2143882 [import] Temporary uploaded file not deleted
  • bug #2136986 [auth] Cannot create database after session timeout
  • bug #1914066 [core] ForceSSL generates incorrectly escaped redirections (this time with the correct fix)
  • [lang] Hungarian update
  • bug #2153970 [core] Properly truncate SQL to avoid half
  • of html tags
  • [lang] Romanian update
  • bug #2161443 [structure] Incorrect index choice shown when
  • modifying an index
  • bug #2127094 [interface] Misleading message after cancelling
  • an action
  • [lang] Croatian update
  • [lang] Finnish update
  • [lang] Polish update
  • [lang] Japanese update
  • patch #2176438 [privileges] Wrong message when changing password
  • bug #2163437 [core] Cannot disable PMA tables
  • bug #2184240 [lang] Problems with Italian language file
  • bug #2187193 [interface] ShowChgPassword setting not respected
  • (3.0.1.1) [security] XSS in a Designer component

New in phpMyAdmin 3.0.1 (Oct 23, 2008)

  • bug #2134126 [GUI] SQL error after sorting a subset
  • [lang] Catalan update
  • [lang] Russian update
  • patch #2143882 [import] Temporary uploaded file not deleted
  • bug #2136986 [auth] Cannot create database after session timeout
  • bug #1914066 [core] ForceSSL generates incorrectly escaped
  • redirections (this time with the correct fix)
  • [lang] Hungarian update
  • bug #2153970 [core] Properly truncate SQL to avoid half
  • of html tags
  • [lang] Romanian update
  • bug #2161443 [structure] Incorrect index choice shown when
  • modifying an index
  • bug #2127094 [interface] Misleading message after cancelling
  • an action
  • [lang] Croatian update
  • [lang] Finnish update
  • [lang] Polish update
  • [lang] Japanese update
  • patch #2176438 [privileges] Wrong message when changing password
  • bug #2163437 [core] Cannot disable PMA tables
  • bug #2184240 [lang] Problems with Italian language file
  • bug #2187193 [interface] ShowChgPassword setting not respected

New in phpMyAdmin 3.0.0 (Sep 30, 2008)

  • Improvements for 3.0.0:
  • [table] support MySQL 5.1 PARTITION: CREATE TABLE / Table structure,
  • partition maintenance
  • [privileges] support for EVENT and TRIGGER
  • [gui] Events
  • minimal support on db structure page
  • export
  • [engines] Maria support
  • [engines] MyISAM and InnoDB: support ROW_FORMAT table option
  • [engines] PBXT: table options, foreign key (relation view, designer)
  • [error handler] NEW handle errors to prevent path disclosure
  • and display/collect errors
  • [mysqlnd] do not display strMysqlLibDiffersServerVersion
  • if the client is mysqlnd
  • [webapp] experimental Mozilla Prism support
  • [export] new plugin "codegen" for NHibernate
  • [export] new export to Texy! markup
  • [config] new parameter CheckConfigurationPermissions
  • [config] new parameter ShowDatabasesCommand
  • [config] new parameter CountTables
  • rfe #1775288 [transformation] proper display if IP-address
  • stored as INT
  • rfe #1758177 [core] Add the Geometry DataTypes
  • rfe #1741101, patch #1798184 UUID default for CHAR(36) PRIMARY KEY
  • rfe #1840165 [interface] Enlarge column name field in vertical mode
  • patch #1847534 [interface] New "Inside field" in db search
  • [GUI] Mootools js library (http://mootools.net) and new parameter
  • InitialSlidersState
  • [core] cache some MySQL stats (do not query them with every
  • page request)
  • [view] clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
  • [pdf] Merged tcpdf 2.2.002 (PHP5 version)
  • prevent search indexes from indexing phpMyAdmin installations
  • [lang] New Bangla
  • [interface] Display options
  • rfe #1962383 [designer] Option to create a PDF page
  • [GUI] Color picker
  • [navi] new parameter LeftDefaultTabTable
  • [display] headwords for sorted column
  • rfe #1692928 [transformation] Option to disable browser
  • transformations
  • [import] Speed optimization to be able to import the sakila database
  • [doc] Documentation for distributing phpMyAdmin in README.VENDOR.
  • Fixes for 3.0.0.x:
  • bug #1910621 [display] part 2: do not display a BINARY content
  • as text
  • [export] properly handle line breaks for YAML
  • bug #1664240 [GUI] css height makes cfg TextareaRows useless
  • bug #1724217 [Create PHP Code] doesn't include newlines for
  • text fields
  • bug #1845605 [i18n] translators.html still uses iso-8859-1
  • bug #1823018 [charset] Edit(Delete) img-links pointing to wrong row
  • bug #1826205 [export] Problems with yaml text export
  • bug #1344768 [database] create/alter table new field can not have
  • empty string as default
  • patch #2007196, Typos in comments
  • bug #1982315 [GUI] Comma and quote in ENUM
  • bug #1970836 [parser] SQL parser is slow
  • bug #2033962 [import] Cannot import zip file
  • [core] Safer handling of temporary files with open_basedir
  • bug #2066923 [display] Navi browse icon does not go to page 1
  • patch #2075263 [auth] Single sign-on and cookie clearing
  • bug #2080963 [charset] Clarify doc and improved code
  • bug [charset] Cannot sort twice on a column when the table name
  • contains accents
  • bug #2113848 [navi] Page number after database switching
  • patch #2115966 [GUI] Checkboxes and IE 7
  • bug #114066 [core] ForceSSL generates incorrectly escaped
  • redirections

New in phpMyAdmin 2.11.9.2 (Sep 22, 2008)

  • bug #2031221 [auth] Links to version number on login screen
  • bug #2032707 [core] PMA does not start if ini_set() is disabled
  • bug #2004915 [bookmarks] Saved queries greater than 1000 chars
  • not displayed
  • bug #2037381 [export] Export type "replace" does not work
  • bug #2037375 [export] DROP PROCEDURE needs IF EXISTS
  • bug #2045512 [export] Numbers in Excel export
  • [lang] Norwegian UTF-8 original file remerged
  • bug #2074250 [parser] Undefined variable seen_from
  • (2.11.9.1) [security] Code execution vulnerability
  • (2.11.9.2) [security] XSS in MSIE using NUL byte

New in phpMyAdmin 3.0.0 RC1 / 2.11.9 (Sep 8, 2008)

  • [table] support MySQL 5.1 PARTITION: CREATE TABLE / Table structure,
  • partition maintenance
  • [privileges] support for EVENT and TRIGGER
  • [gui] Events
  • minimal support on db structure page
  • export
  • [engines] Maria support
  • [engines] MyISAM and InnoDB: support ROW_FORMAT table option
  • [engines] PBXT: table options, foreign key (relation view, designer)
  • [error handler] NEW handle errors to prevent path disclosure
  • and display/collect errors
  • [mysqlnd] do not display strMysqlLibDiffersServerVersion
  • if the client is mysqlnd
  • [webapp] experimental Mozilla Prism support
  • [export] new plugin "codegen" for NHibernate
  • [export] new export to Texy! markup
  • [config] new parameter CheckConfigurationPermissions
  • [config] new parameter ShowDatabasesCommand
  • [config] new parameter CountTables
  • rfe #1775288 [transformation] proper display if IP-address
  • stored as INT
  • rfe #1758177 [core] Add the Geometry DataTypes
  • rfe #1741101, patch #1798184 UUID default for CHAR(36) PRIMARY KEY
  • rfe #1840165 [interface] Enlarge column name field in vertical mode
  • patch #1847534 [interface] New "Inside field" in db search
  • [GUI] Mootools js library (http://mootools.net) and new parameter
  • InitialSlidersState
  • [core] cache some MySQL stats (do not query them with every
  • page request)
  • [view] clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
  • [pdf] Merged tcpdf 2.2.002 (PHP5 version)
  • prevent search indexes from indexing phpMyAdmin installations
  • [lang] New Bangla
  • [interface] Display options
  • rfe #1962383 [designer] Option to create a PDF page
  • [GUI] Color picker
  • [navi] new parameter LeftDefaultTabTable
  • [display] headwords for sorted column
  • rfe #1692928 [transformation] Option to disable browser
  • transformations
  • [import] Speed optimization to be able to import the sakila database
  • [doc] Documentation for distributing phpMyAdmin in README.VENDOR.

New in phpMyAdmin 3.0.0 Alpha (Aug 11, 2008)

  • support MySQL 5.1 PARTITION: CREATE TABLE / Table structure, partition maintenance
  • support for EVENT and TRIGGER
  • Events
  • minimal support on db structure page
  • export
  • Maria support
  • MyISAM and InnoDB: support ROW_FORMAT table option
  • PBXT: table options, foreign key (relation view, designer)
  • support SweKey hardware authentication
  • NEW handle errors to prevent path disclosure and display/collect errors
  • do not display strMysqlLibDiffersServerVersion if the client is mysqlnd
  • experimental Mozilla Prism support
  • new plugin "codegen" for NHibernate
  • new export to Texy! markup
  • new parameter CheckConfigurationPermissions
  • new parameter ShowDatabasesCommand
  • new parameter CountTables
  • proper display if IP-address stored as INT
  • Add the Geometry DataTypes
  • patch #1798184 UUID default for CHAR(36) PRIMARY KEY
  • Enlarge column name field in vertical mode
  • New "Inside field" in db search
  • Mootools js library and new parameter InitialSlidersState
  • cache some MySQL stats (do not query them with every page request)
  • clearer dialog WITH (CASCADED | LOCAL) CHECK OPTION
  • Merged tcpdf 2.2.002 (PHP5 version)
  • prevent search indexes from indexing phpMyAdmin installations
  • New Bangla
  • Display options
  • Option to create a PDF page
  • Color picker
  • new parameter LeftDefaultTabTable
  • headwords for sorted column
  • Option to disable browser transformations
  • Speed optimization to be able to import the sakila database
  • Documentation for distributing phpMyAdmin in README.VENDOR.

New in phpMyAdmin 2.11.8.1 (Jul 28, 2008)

  • patch #1987593 [interface] Table list pagination in navi
  • bug #1989081 [profiling] Profiling causes query to be executed again (really causes a problem in case of INSERT/UPDATE)
  • bug #1990342 [import] SQL file import very slow on Windows
  • bug [XHTML] problem with tabindex and radio fields
  • bug #1971221 [interface] tabindex not set correctly
  • bug [views] VIEW name created via the GUI was not protected with backquotes
  • bug #1989813 [interface] Deleting multiple views (space in name)
  • bug #1992628 [parser] SQL parser removes essential space
  • bug #1989281 [export] CSV for MS Excel incorrect escaping of double quotes
  • bug #1959855 [interface] Font size option problem when no config file
  • bug #1982489 [relation] Relationship view should check for changes
  • bug [history] Do not save too big queries in history
  • [security] Do not show version info on login screen
  • bug #2018595 [import] Potential data loss on import resubmit
  • patch #2020630 [export] Safari and timedate
  • bug #2022182 [import, export] Import/Export fails because of Mac files
  • [security] protection against cross-frame scripting and new directive AllowThirdPartyFraming
  • [security] possible XSS during setup
  • [interface] revert language changing problem introduced with 2.11.7.1

New in phpMyAdmin 2.11.7.1 (Jul 15, 2008)

  • bug #1908719 [interface] New field cannot be auto-increment and primary key
  • [dbi] Incorrect interpretation for some mysqli field flags
  • bug #1910621 [display] part 1: do not display a TEXT utf8_bin as BLOB (fixed for mysqli extension only)
  • [interface] sanitize the after_field parameter, thanks to Norman Hippert
  • [structure] do not remove the BINARY attribute in drop-down
  • bug #1955386 [session] Overriding session.hash_bits_per_character
  • [interface] sanitize the table comments in table print view, thanks to Norman Hippert
  • bug #1939031 Auto_Increment selected for TimeStamp by Default
  • patch #1957998 [display] No tilde for InnoDB row counter when we know it for sure, thanks to Vladyslav Bakayev - dandy76
  • bug #1955572 [display] alt text causes duplicated strings
  • bug #1762029 [interface] Cannot upload BLOB into existing row
  • bug #1981043 [export] HTML in exports getting corrupted, thanks to Jason Judge - jasonjudge
  • bug #1936761 [interface] BINARY not treated as BLOB: update/delete issues
  • protection against XSS when register_globals is on and .htaccess has no effect, thanks to Tim Starling
  • bug #1996943 [export] Firefox 3 and .sql.gz (corrupted); detect Gecko 1.9, thanks to Juergen Wind
  • (2.11.7.1) [security] XSRF/CSRF by manipulating the db, convcharset and collation_connection parameters, thanks to YGN Ethical Hacker Group

New in phpMyAdmin 2.11.7 (Jun 23, 2008)

  • bug #1908719 [interface] New field cannot be auto-increment and
  • primary key
  • [dbi] Incorrect interpretation for some mysqli field flags
  • bug #1910621 [display] part 1: do not display a TEXT utf8_bin
  • as BLOB (fixed for mysqli extension only)
  • [interface] sanitize the after_field parameter,
  • thanks to Norman Hippert
  • [structure] do not remove the BINARY attribute in drop-down
  • bug #1955386 [session] Overriding session.hash_bits_per_character
  • [interface] sanitize the table comments in table print view,
  • thanks to Norman Hippert
  • bug #1939031 Auto_Increment selected for TimeStamp by Default
  • patch #1957998 [display] No tilde for InnoDB row counter when
  • we know it for sure, thanks to Vladyslav Bakayev - dandy76
  • bug #1955572 [display] alt text causes duplicated strings
  • bug #1762029 [interface] Cannot upload BLOB into existing row
  • bug #1981043 [export] HTML in exports getting corrupted,
  • thanks to Jason Judge - jasonjudge
  • bug #1936761 [interface] BINARY not treated as BLOB:
  • update/delete issues
  • protection against XSS when register_globals is on and .htaccess
  • has no effect, thanks to Tim Starling
  • bug #1996943 [export] Firefox 3 and .sql.gz (corrupted);
  • detect Gecko 1.9, thanks to Juergen Wind

New in phpMyAdmin 2.11.5 (Mar 4, 2008)

  • bug #1862661 [GUI] Warn about rename deleting database
  • bug #1866041 [interface] Incorrect sorting with AS
  • bug #1871038 [import] Notice: undefined variable first_sql_delimiter
  • bug #1873110 [export] Problem exporting with a LIMIT clause
  • bug #1871164 [GUI] Empty and navigation frame synch.
  • patch #1873188 [GUI] Making db pager work when js is disabled, thanks to J�rgen Wind - windkiel
  • bug #1875010 [auth] MySQL server and client version mismatch (mysql ext.)
  • patch #1879031 [transform] dateformat transformation and UNIX timestamps, thanks to Tim Steiner - spam38
  • bug [import] Do not verify a missing enclosing character for CSV, because files generated by Excel don't have any enclosing character
  • bug #1799691 [export] "Propose table structure" and Export
  • bug #1884911 [GUI] Space usage
  • bug #1863326 [GUI] Wrong error message / no edit (Suhosin)
  • bug #1887204 [GUI] Order columns in result list messing up query
  • patch #1893538 [GUI] Display issues on Opera 9.50, thanks to J�rgen Wind - windkiel
  • bug [GUI] Do not display the database name used by the previous user, thanks to Ronny G�rner
  • bug [security] Remove cookies from Array for better coexistence with other applications, thanks to Richard Cunningham. See PMASA-2008-1.

New in phpMyAdmin 2.11.4 (Jan 15, 2008)

  • bug #1843428 [GUI] Space issue with DROP/DELETE/ALTER TABLE
  • bug #1807816 [search] regular expression search doesn't work with
  • backslashes
  • bug #1843463 [GUI] DROP PROCEDURE does not show alert
  • bug #1835904 [GUI] Back link after a SQL error forgets the query
  • bug #1835654 [core] wrong escaping when using double quotes
  • bug #1817612 [cookies] Wrong cookie path on IIS with PHP-CGI,
  • thanks to Carsten Wiedmann
  • bug #1848889 [export] export trigger should use
  • DROP TRIGGER IF EXISTS
  • bug #1851833 [display] Sorting forgets an explicit LIMIT
  • (fix for sorting on column headers)
  • bug #1764182 [cookies] Suhosin cookie encryption breaks phpMyAdmin
  • bug #1798786 [import] Wrong error when a string contains semicolon
  • bug #1813508 [login] Missing parameter: field after re-login
  • bug #1710144 [parser] Space after COUNT breaks Export but not Query
  • bug #1783620 [parser] Subquery results without "as" are ignored
  • bug #1821264 [display] MaxTableList and INFORMATION_SCHEMA
  • bug #1859460 [display] Operations and many databases
  • bug #1814679 [display] Database selection pagination when
  • switching servers
  • patch #1861717 [export] CSV Escape character not exported right,
  • thanks to nicolasdigraf
  • bug #1864468 [display] Theme does not switch to darkblue_orange
  • bug #1847409 [security] Path disclosure on
  • darkblue_orange/layout.inc.php,
  • thanks to J�rgen Wind windkiel

New in phpMyAdmin 2.11.4 RC1 (Jan 7, 2008)

  • Bug #1843428 [GUI] Space issue with DROP/DELETE/ALTER TABLE
  • Bug #1807816 [search] regular expression search doesn't work with backslashes
  • Bug #1843463 [GUI] DROP PROCEDURE does not show alert
  • Bug #1835904 [GUI] Back link after a SQL error forgets the query
  • Bug #1835654 [core] wrong escaping when using double quotes
  • Bug #1817612 [cookies] Wrong cookie path on IIS with PHP-CGI
  • Bug #1848889 [export] export trigger should use DROP TRIGGER IF EXISTS
  • Bug #1851833 [display] Sorting forgets an explicit LIMIT (fix for sorting on column headers)
  • Bug #1764182 [cookies] Suhosin cookie encryption breaks phpMyAdmin
  • Bug #1798786 [import] Wrong error when a string contains semicolon
  • Bug #1813508 [login] Missing parameter: field after re-login
  • Bug #1710144 [parser] Space after COUNT breaks Export but not Query
  • Bug #1783620 [parser] Subquery results without "as" are ignored
  • Bug #1821264 [display] MaxTableList and INFORMATION_SCHEMA
  • Bug #1859460 [display] Operations and many databases

New in phpMyAdmin 2.11.3 (Dec 11, 2007)

  • Patch #1818389 to remove a notice (failed to flush buffer)
  • Patch #1821154, HTTP authentication: fix auth working With php/mod_fastcgi
  • Wrong default charset in case of broken session
  • Bug #1824506 [profiling] Profile command repeated on Older MySQL servers
  • Bug #1825172 [export] Exporting and functions
  • Bug #1817224 [import] Incorrect detection of file_uploads In some cases
  • Bug #1777249 [display] Do not underline links in left panel
  • Bug #1826022 [privileges] unable to add user (MySQL 3.23) Since PMA 2.11.2
  • Bug #1823045 [import] Error importing file with lowercase"delimiter"
  • Bug #1828913 [structure] Can't set FULLTEXT index on CHAR column
  • Bug #1804081 [export] export on server doesn't obey AllowAnyWhereRecoding
  • Bug #1789988 [display] space before SHOW COLUMNS
  • Bug #1831646 [table creation] Error in CREATE TABLE with multiple Primary keys and AUTO_INCREMENT
  • [display] Division by zero when showing all records (page selector)
  • Bug #1828265 [privileges] No weird characters in generated password

New in phpMyAdmin 2.11.3 RC1 (Dec 3, 2007)

  • patch #1818389 to remove a notice (failed to flush buffer)
  • patch #1821154, HTTP authentication: fix auth working with php/mod_fastcgi
  • wrong default charset in case of broken session
  • bug #1824506 [profiling] Profile command repeated on older MySQL servers
  • bug #1825172 [export] Exporting and functions
  • bug #1817224 [import] Incorrect detection of file_uploads in some cases
  • bug #1777249 [display] Do not underline links in left panel
  • bug #1826022 [privileges] unable to add user (MySQL 3.23) since PMA 2.11.2
  • bug #1823045 [import] Error importing file with lowercase "delimiter"
  • bug #1828913 [structure] Can't set FULLTEXT index on CHAR column
  • bug #1804081 [export] export on server doesn't obey
  • AllowAnyWhereRecoding
  • bug #1789988 [display] space before SHOW COLUMNS
  • bug #1831646 [table creation] Error in CREATE TABLE with multiple
  • primary keys and AUTO_INCREMENT
  • [display] Division by zero when showing all records (page selector)
  • bug #1828265 [privileges] No weird characters in generated password
  • bug #1759194 [import] open_basedir warning
  • bug #1793948 [parser] ROW_FORMAT incorrectly parsed
  • undefined PMA_MYSQL_INT_VERSION when no default server is set
  • bug #1763343 [session] Behavior with session.auto_start enabled
  • [lang] Hungarian update
  • patch #1837691 [query window] js errors
  • patch #1839052 [lang] catalan not in UTF-8
  • patch #1838626 [GUI] Login interface broken on Konqueror

New in phpMyAdmin 2.11.2.1 (Nov 13, 2007)

  • patch #1791576 HTTP auth: support REDIRECT_REMOTE_USER,
  • thanks to Allard
  • [lang] Serbian update, thanks to Mihailo Stefanovic
  • bug #1798841 [relations] Copying db does not copy internal relations
  • bug #1798646 [display] Character ' ' in query wrongly interpreted
  • bug #1801919 [themes] Do not use NaviDatabaseNameColor for fieldset
  • legend
  • bug #1764735 [core] Designer: PDF error when deleting a table
  • bug #1764195 [views] DROP button does not work on defective views
  • bug #1805773 [relations] browse foreign values: return values not
  • escaped, thanks to Alex Rambau
  • bug #1807923 [login] Login with html entities in password fails
  • [core] Undefined variable when creating a table that exists
  • patch #1808578 Changes in font size were no longer detected
  • after patch #1787915
  • [lang] Croatian update, thanks to Renato Pavicic
  • patch #1807615 [GUI] Display patch for column rights in Opera
  • bug #1811519 Can't delete user with a german umlaut.
  • bug #1811519 [privileges] fixed used collation for accessing
  • mysql.user in server privileges
  • it should not be possible to move or copy a table to
  • information_schema
  • bug #1814733 win: copy db to mixed name db fails
  • bug #1777249 [display] Remove horizontal lines in navigation panel
  • bug #1805102 [display] TextareaAutoSelect issues: set this parameter
  • default value to false to help cut&paste from a terminal window;
  • also set focus to the textarea
  • bug #1814463 [display] Wrong database size
  • bug #1811527 [display] Problem with links to the MySQL manual
  • patch #1817529 [auth] Incorrect login via URL when
  • AllowArbitraryServer is true, thanks to Juergen Wind
  • (2.11.2.1) fixed possible SQL injection using database name
  • (2.11.2.1) fixed possible XSS in database name,
  • thanks to Omer Singer, The DigiTrust Group

New in phpMyAdmin 2.11.2-rc1 (Oct 24, 2007)

  • Patch #1791576 HTTP auth: support REDIRECT_REMOTE_USER
  • [lang] Serbian update, thanks to Mihailo Stefanovic
  • Bug #1798841 [relations] Copying db does not copy internal relations
  • Bug #1798646 [display] Character ' ' in query wrongly interpreted
  • Bug #1801919 [themes] Do not use NaviDatabaseNameColor for fieldset legend
  • Bug #1764735 [core] Designer: PDF error when deleting a table
  • Bug #1764195 [views] DROP button does not work on defective views
  • Bug #1805773 [relations] browse foreign values: return values not escaped, thanks to Alex Rambau
  • Bug #1807923 [login] Login with html entities in password fails
  • [core] Undefined variable when creating a table that exists
  • Patch #1808578 Changes in font size were no longer detected after patch #1787915
  • [lang] Croatian update, thanks to Renato Pavicic
  • Patch #1807615 [GUI] Display patch for column rights in Opera
  • Bug #1811519 Can't delete user with a german umlaut
  • Bug #1811519 [privileges] fixed used collation for accessing mysql.user in server privileges

New in phpMyAdmin 2.11.1.2 (Oct 18, 2007)

  • bug #1783667 [export] NO_AUTO_VALUE_ON_ZERO and MySQL version
  • bug #1780098 [GUI] Logout causes CSS loss, thanks to Juergen Wind
  • . incorrect field ids, thanks to Michael Keck
  • bug #1787522 [view] wrong choice in algorithm drop-down
  • bug #1777620 [GUI] Table Print preview: missing column header, thanks to Mario Rohkr�mer
  • Do not display "Your MySQL library..." if only the Z part of X.Y.Z version is different
  • bugs #1767759, 1216521 [data] Duplicate entry error Browse feature:
  • this minor feature removed due to its complexity
  • bug #1774825 [operations] Rename database loses charset info
  • bug #1791568 [core] Undefined cfg, thanks to Christian Schmidt
  • bug #1782332 [structure] New table form does not overtake data
  • bug #1793763 [requirements] minimum PHP should be 4.2.0
  • patch #1787915 Avoid CSS reloading on every click, thanks to Juergen Wind
  • bug #1798627 [GUI] Wrong storage engine displayed
  • - (2.11.1.1) security fix on setup.php
  • (2.11.1.2) security fix on server_status.php and other possible XSS issues with PHP_SELF, PATH_INFO, REQUEST_URI

New in phpMyAdmin 2.11.1 (Sep 21, 2007)

  • bug #1783667 [export] NO_AUTO_VALUE_ON_ZERO and MySQL version
  • bug #1780098 [GUI] Logout causes CSS loss, thanks to Juergen Wind
  • . incorrect field ids, thanks to Michael Keck
  • bug #1787522 [view] wrong choice in algorithm drop-down
  • bug #1777620 [GUI] Table Print preview: missing column header, thanks to Mario Rohkr�mer
  • Do not display "Your MySQL library..." if only the Z part of X.Y.Z version is different
  • bugs #1767759, 1216521 [data] Duplicate entry error Browse feature:
  • this minor feature removed due to its complexity
  • bug #1774825 [operations] Rename database loses charset info
  • bug #1791568 [core] Undefined cfg, thanks to Christian Schmidt
  • bug #1782332 [structure] New table form does not overtake data
  • bug #1793763 [requirements] minimum PHP should be 4.2.0
  • patch #1787915 Avoid CSS reloading on every click, thanks to Juergen Wind
  • bug #1798627 [GUI] Wrong storage engine displayed

New in phpMyAdmin 2.11.0-rc2 (Aug 22, 2007)

  • [import] support handling of DELIMITER to mimic mysql CLI,
  • thanks to fb1
  • improved PHP 6 compatibility
  • [core] added PMA_fatalError() and made use of it
  • [doc] changed all documentation in config.inc.php
  • to phpDocumentor style
  • [data] support for CREATE VIEW from query results
  • [gui] dropped css/ folder and moved into root of PMA
  • [l10n] new: Sinhala, Macedonian
  • [export] YAML export (see yaml.org), thanks to Bryce Thornton
  • [upload] moved file upload functionality into own class
  • [upload] make use of cfg['TempDir'] for file uploads
  • [server] improved display of binary logs
  • [data] better error handling in tbl_create.php
  • [routines] from Patch #1649881, thanks to Mike Beck
  • [querywindow] store sql history in session
  • [querywindow] sql history now without db too
  • [querywindow] tweaks in sql history view
  • [export] Native Excel (Spreadsheet_Excel_Writer) improvements,
  • thanks to Christian Schmidt
  • [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
  • RFE #1435922 [gui] navigation frame shows listing of databases
  • when none selected
  • [data] support BIT datatype (under mysqli),
  • thanks to Christian Schmidt
  • [display] automatic confirmation for sort by key,
  • thanks to Juergen Wind
  • [data] can now choose the number of insert rows
  • RFE #1704779 [gui] link documentation from login page
  • RFE #1513345 [setup] check control user connection during setup
  • [structure] TRIGGERS: display/edit/drop/SQL export
  • [browse] store browse state in session per query
  • [gui] Insert/Edit: no longer display the Go button each 15 lines
  • but just at the end of a row
  • [gui] Query window: use verbose server name if any
  • [auth] patch #1712514 specify host for single signon,
  • thanks to Thierry
  • [gui] Navigator for the db list in the navigation panel
  • [gui] Navigator for the table list in the content panel
  • [display] Support for MySQL 5.0.37 profiling
  • RFE #1743983 [gui] Replace max_characters by a configurable param:
  • cfg['MaxCharactersInDisplayedSQL']
  • [display] patch #1749705, Allow multibyte characters in number
  • formatting, thanks to garas
  • [privileges] Support password hashing on the Edit Privileges
  • interface
  • [gui] Export: Select All/Unselect All over the choices,
  • thanks to Florian Schmitz
  • Fixes:
  • bug #1674914 [structure] changing definition of a TIMESTAMP field
  • bug #1615530 [upload] added more specific error message
  • if field upload fails
  • bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
  • bug #1668724 JavaScript focus login Opera
  • bug #1666657 [auth] Cookie password delete on timeout / inactivity
  • bug #1648802 different mysql library and server version
  • bug #1662976 [auth] Authentication fails when controluser/pass
  • is set
  • bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
  • bug #1523747 [innodb] make warning about row count more visible
  • bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
  • bug #1679440 Added FAQ entry about header errors under IIS caused by
  • an end-of-line character
  • [gui] avoid displaying a wide selector in server selection
  • bug #1614004 [relation] foreign key spanning multiple columns are
  • incorrectly displayed
  • bug #1681598 [interface] Edit next row
  • bug #1688053 [export] Wrong export of binary character fields
  • bug #1498281 [parser] Wrong primary key used for displaying results
  • with subquery
  • bug #1699772 Visual space bug in table name (in browser)
  • bug #1699532 Cause of data manipulation issues: implemented changes
  • as suggested by crisp_; still have to work on updating an ENUM value
  • bug #1747215 Export emits blanks at line ends
  • bug #1751172 Do not export data when exporting a single VIEW
  • bug #1755339 Warn about rename database actually being copy/delete
  • bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
  • bug #1727138 HTML not encoded (more than 1000 characters)
  • bug #1746186 LeftLogoLink fails if set to some external site
  • bug #1759528 browse_foreigners fails due to newlines,
  • thanks to Hanno Boeck
  • bug #1751553 Drop-down instead of input when editing

New in phpMyAdmin 2.11.0-rc2 (Aug 21, 2007)

  • [import] support handling of DELIMITER to mimic mysql CLI,
  • thanks to fb1
  • improved PHP 6 compatibility
  • [core] added PMA_fatalError() and made use of it
  • [doc] changed all documentation in config.inc.php
  • to phpDocumentor style
  • [data] support for CREATE VIEW from query results
  • [gui] dropped css/ folder and moved into root of PMA
  • [l10n] new: Sinhala, Macedonian
  • [export] YAML export (see yaml.org), thanks to Bryce Thornton
  • [upload] moved file upload functionality into own class
  • [upload] make use of cfg['TempDir'] for file uploads
  • [server] improved display of binary logs
  • [data] better error handling in tbl_create.php
  • [routines] from Patch #1649881, thanks to Mike Beck
  • [querywindow] store sql history in session
  • [querywindow] sql history now without db too
  • [querywindow] tweaks in sql history view
  • [export] Native Excel (Spreadsheet_Excel_Writer) improvements,
  • thanks to Christian Schmidt
  • [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
  • RFE #1435922 [gui] navigation frame shows listing of databases
  • when none selected
  • [data] support BIT datatype (under mysqli),
  • thanks to Christian Schmidt
  • [display] automatic confirmation for sort by key,
  • thanks to Juergen Wind
  • [data] can now choose the number of insert rows
  • RFE #1704779 [gui] link documentation from login page
  • RFE #1513345 [setup] check control user connection during setup
  • [structure] TRIGGERS: display/edit/drop/SQL export
  • [browse] store browse state in session per query
  • [gui] Insert/Edit: no longer display the Go button each 15 lines
  • but just at the end of a row
  • [gui] Query window: use verbose server name if any
  • [auth] patch #1712514 specify host for single signon,
  • thanks to Thierry
  • [gui] Navigator for the db list in the navigation panel
  • [gui] Navigator for the table list in the content panel
  • [display] Support for MySQL 5.0.37 profiling
  • RFE #1743983 [gui] Replace max_characters by a configurable param:
  • cfg['MaxCharactersInDisplayedSQL']
  • [display] patch #1749705, Allow multibyte characters in number
  • formatting, thanks to garas
  • [privileges] Support password hashing on the Edit Privileges
  • interface
  • [gui] Export: Select All/Unselect All over the choices,
  • thanks to Florian Schmitz
  • Fixes:
  • bug #1674914 [structure] changing definition of a TIMESTAMP field
  • bug #1615530 [upload] added more specific error message
  • if field upload fails
  • bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
  • bug #1668724 JavaScript focus login Opera
  • bug #1666657 [auth] Cookie password delete on timeout / inactivity
  • bug #1648802 different mysql library and server version
  • bug #1662976 [auth] Authentication fails when controluser/pass
  • is set
  • bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
  • bug #1523747 [innodb] make warning about row count more visible
  • bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
  • bug #1679440 Added FAQ entry about header errors under IIS caused by
  • an end-of-line character
  • [gui] avoid displaying a wide selector in server selection
  • bug #1614004 [relation] foreign key spanning multiple columns are
  • incorrectly displayed
  • bug #1681598 [interface] Edit next row
  • bug #1688053 [export] Wrong export of binary character fields
  • bug #1498281 [parser] Wrong primary key used for displaying results
  • with subquery
  • bug #1699772 Visual space bug in table name (in browser)
  • bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
  • bug #1747215 Export emits blanks at line ends
  • bug #1751172 Do not export data when exporting a single VIEW
  • bug #1755339 Warn about rename database actually being copy/delete
  • bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
  • bug #1727138 HTML not encoded (more than 1000 characters)
  • bug #1746186 LeftLogoLink fails if set to some external site
  • bug #1759528 browse_foreigners fails due to newlines,thanks to Hanno Boeck

New in phpMyAdmin 2.11.0-rc1 (Aug 3, 2007)

  • [import] support handling of DELIMITER to mimic mysql CLI, thanks to fb1 improved PHP 6 compatibility
  • [core] added PMA_fatalError() and made use of it
  • [doc] changed all documentation in config.inc.php to phpDocumentor style
  • [data] support for CREATE VIEW from query results
  • [gui] dropped css/ folder and moved into root of PMA
  • [l10n] new: Sinhala, Macedonian
  • [export] YAML export (see yaml.org), thanks to Bryce Thornton
  • [upload] moved file upload functionality into own class
  • [upload] make use of cfg['TempDir'] for file uploads
  • [server] improved display of binary logs
  • [data] better error handling in tbl_create.php
  • [routines] from Patch #1649881, thanks to Mike Beck
  • [querywindow] store sql history in session
  • [querywindow] sql history now without db too
  • [querywindow] tweaks in sql history view
  • [export] Native Excel (Spreadsheet_Excel_Writer) improvements, thanks to Christian Schmidt
  • [doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
  • RFE #1435922 [gui] navigation frame shows listing of databases when none selected
  • [data] support BIT datatype (under mysqli), thanks to Christian Schmidt
  • [display] automatic confirmation for sort by key, thanks to Juergen Wind
  • [data] can now choose the number of insert rows
  • RFE #1704779 [gui] link documentation from login page
  • RFE #1513345 [setup] check control user connection during setup
  • [structure] TRIGGERS: display/edit/drop/SQL export
  • [browse] store browse state in session per query
  • [gui] Insert/Edit: no longer display the Go button each 15 lines but just at the end of a row
  • [gui] Query window: use verbose server name if any
  • [auth] patch #1712514 specify host for single signon, hanks to Thierry
  • [gui] Navigator for the db list in the navigation panel
  • [gui] Navigator for the table list in the content panel
  • [display] Support for MySQL 5.0.37 profiling
  • RFE #1743983 [gui] Replace max_characters by a configurable param: cfg['MaxCharactersInDisplayedSQL']
  • [display] patch #1749705, Allow multibyte characters in number formatting, thanks to garas
  • [privileges] Support password hashing on the Edit Privileges interface
  • [gui] Export: Select All/Unselect All over the choices, thanks to Florian Schmitz
  • Fixes:
  • bug #1674914 [structure] changing definition of a TIMESTAMP field
  • bug #1615530 [upload] added more specific error message if field upload fails
  • bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
  • bug #1668724 JavaScript focus login Opera
  • bug #1666657 [auth] Cookie password delete on timeout / inactivity
  • bug #1648802 different mysql library and server version
  • bug #1662976 [auth] Authentication fails when controluser/pass is set
  • bug #1643758 [import] Error #1264 importing NULL values in MySQL 5.0
  • bug #1523747 [innodb] make warning about row count more visible
  • bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
  • bug #1679440 Added FAQ entry about header errors under IIS caused by an end-of-line character
  • [gui] avoid displaying a wide selector in server selection
  • bug #1614004 [relation] foreign key spanning multiple columns are incorrectly displayed
  • bug #1681598 [interface] Edit next row
  • bug #1688053 [export] Wrong export of binary character fields
  • bug #1498281 [parser] Wrong primary key used for displaying results with subquery
  • bug #1699772 Visual space bug in table name (in browser)
  • bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
  • bug #1747215 Export emits blanks at line ends
  • bug #1751172 Do not export data when exporting a single VIEW
  • bug #1755339 Warn about rename database actually being copy/delete
  • bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
  • bug #1727138 HTML not encoded (more than 1000 characters)
  • bug #1746186 LeftLogoLink fails if set to some external site
  • bug #1759528 browse_foreigners fails due to newlines, thanks to Hanno Boeck

New in phpMyAdmin 2.11.0 Beta 1 (Jul 26, 2007)

  • Improvements:
  • [Import] support handling of DELIMITER to mimic mysql CLI, thanks to fb1
  • improved PHP 6 compatibility
  • [Core] added PMA_fatalError() and made use of it
  • [doc] changed all documentation in config.inc.php
  • to phpDocumentor style
  • [Data] support for CREATE VIEW from query results
  • [Gui] dropped css/ folder and moved into root of PMA
  • [L10n] new: Sinhala, Macedonian
  • [Export] YAML export (see yaml.org), thanks to Bryce Thornton
  • [Upload] moved file upload functionality into own class
  • [Upload] make use of cfg['TempDir'] for file uploads
  • [Server] improved display of binary logs
  • [Data] better error handling in tbl_create.php
  • [Routines] from Patch #1649881, thanks to Mike Beck
  • [Querywindow] store sql history in session
  • [Querywindow] sql history now without db too
  • [Querywindow] tweaks in sql history view
  • [Export] Native Excel (Spreadsheet_Excel_Writer) improvements, thanks to Christian Schmidt
  • [Doc] requirement of mcrypt on 64-bit, thanks to Isaac Bennetch
  • RFE #1435922 [gui] navigation frame shows listing of databases when none selected
  • [Data] support BIT datatype (under mysqli), thanks to Christian Schmidt
  • [Display] automatic confirmation for sort by key, thanks to Juergen Wind
  • [Data] can now choose the number of insert rows
  • RFE #1704779 [gui] link documentation from login page
  • RFE #1513345 [setup] check control user connection during setup
  • [Structure] TRIGGERS: display/edit/drop/SQL export
  • [Browse] store browse state in session per query
  • [Gui] Insert/Edit: no longer display the Go button each 15 lines but just at the end of a row
  • [Gui] Query window: use verbose server name if any
  • [Auth] patch #1712514 specify host for single signon, thanks to Thierry
  • [Gui] Navigator for the db list in the navigation panel
  • [Gui] Navigator for the table list in the content panel
  • [Display] Support for MySQL 5.0.37 profiling
  • RFE #1743983 [gui] Replace max_characters by a configurable param: cfg['MaxCharactersInDisplayedSQL']
  • [Display] patch #1749705, Allow multibyte characters in number formatting, thanks to garas
  • [Privileges] Support password hashing on the Edit Privileges interface
  • [Gui] Export: Select All/Unselect All over the choices, thanks to Florian Schmitz
  • Fixes:
  • Bug #1674914 [structure] changing definition of a TIMESTAMP field
  • Bug #1615530 [upload] added more specific error message if field upload fails
  • Bug #1627210, #1083301, #1482401 [data] warning on duplicate indexes
  • Bug #1668724 JavaScript focus login Opera
  • Bug #1666657 [auth] Cookie password delete on timeout / inactivity
  • Bug #1648802 different mysql library and server version
  • Bug #1662976 [auth] Authentication fails when controluser/pass is set
  • Bug #1643758 [Import] Error #1264 importing NULL values in MySQL 5.0
  • Bug #1523747 [innodb] make warning about row count more visible
  • Bug #1676012 [auth] strip non-US-ASCII characters (RFC2616)
  • Bug #1679440 Added FAQ entry about header errors under IIS caused by an end-of-line character
  • [gui] avoid displaying a wide selector in server selection
  • Bug #1614004 [relation] foreign key spanning multiple columns are incorrectly displayed
  • Bug #1681598 [interface] Edit next row
  • Bug #1688053 [export] Wrong export of binary character fields
  • Bug #1498281 [parser] Wrong primary key used for displaying results with subquery
  • Bug #1699772 Visual space Bug in table name (in browser)
  • Bug #1699532 Cause of data manipulation issues: implemented changes as suggested by crisp_; still have to work on updating an ENUM value
  • Bug #1747215 Export emits blanks at line ends
  • Bug #1751172 Do not export data when exporting a single VIEW
  • Bug #1755339 Warn about rename dataase actually being copy/delete
  • Bug #1746921 Left frame shrinks on db change, thanks to Juergen Wind
  • Bug #1727138 HTML not encoded (more than 1000 characters)
  • Bug #1746186 LeftLogoLink fails if set to some external site

New in phpMyAdmin 2.10.3-rc1 (Jul 17, 2007)

  • Fixed bug #1734285 Copy database with VIEWs
  • Fixed bug #1722502 DROP TABLE in export VIEW
  • Fixed bug #1729027 Sorting results of VIEW browsing
  • Fixed bug #1733012 Unwanted table alias in delete button
  • Fixed bug #1736405 Pretty printer and HTML line breaks
  • Fixed bug #1745257 Invalid DB name is still displayed
  • Fixed bug #1730367 Calendar "Go" has no effect
  • Patch #1750500 Smaller file for favicon.ico, thanks to Thijs Kinkhorst
  • Fixed bug #1748633 Incorrect parameter validation for VIEWs
  • [lang] Russian revision, thanks to Victor Volkov and the users of php-myadmin.ru
  • Do not try to delete an internal relation if we just deleted an InnoDB one

New in phpMyAdmin 2.10.1 (Apr 25, 2007)

  • bug #1541147 [js] '#' in database names not correctly handled by queywindow.js
  • bug #1671403 [parser] using "client" as table name
  • bug #1672379 [core] Call to undefined function PMA_removeCookie()
  • bug [core] undefined variable in libraries/tbl_replace_fields.inc.php
  • bug [gui] query window icon did not work, thanks to Juergen Wind - windkiel
  • [general] use PMA_getenv('PHP_SELF')
  • bug #1676033 [core] pow(int,int) causes overflow
  • bug #1680952 [core] undefined function PMA_getUvaCondition()
  • bug #1596328 [export] drop support for POSTGRESQL compatibility mode
  • bug #1609443 [privileges] Grant all priv. on wildcard name (fix message)
  • bug #1567317 [sqp] Syntax highlighter: extra spaces
  • bug #1239401 [sqp] table dot numeric field name
  • bug #1672789 [sqp] Undefined offset: 4 in sqlparser.lib.php #1674
  • bug #1682044 [export] Export file even if file not selected
  • bug #1664212 querywindow loses url encoded characters
  • replaced ctype_digit() with is_numeric()
  • [config] clean cookies on phpMyAdmin upgrade
  • bug #1674972 [export] no export with �m%
  • bug #1667887 HTML maxlength
  • bug #1679055 #1050 - Table 'table name' already exists
  • patch #1681620 [interface] support reordering of cfg['ColumnTypes'], thanks to Leonard den Ottolander
  • bug #1690718 Can't edit if BLOB and no PK
  • bug #1672636 [export] PDF export too wide
  • [lang] brazilian-portuguese update, thanks to Airon Luis Pereira
  • patch #1698964 javascript typo, thanks to Corey Hollaway
  • bug #1703897 [css] undefined index 'js_frame'
  • bug #1690561 Blobs being cleared on Edit of row
  • bug #1679801 [core] XSS vulnerability in PMA_sanitize(), thanks to sp3x SecurityReason
  • bug #1704467 XSS vulnerability in browse_foreigners.php, thanks to sp3x SecurityReason

New in phpMyAdmin 2.9.2 RC1 (Jan 10, 2007)

  • improved support for web clusters
  • deleting a user under MySQL 4.1.x
  • DELIMITER in export no longer commented out
  • export of query results and procedure definitions
  • detection of a binary column
  • problem on 64-bit systems
  • granting all privileges on a wildcard name
  • verification on encrypted zip files
  • security fixes

New in phpMyAdmin 2.9.1.1 (Nov 21, 2006)

  • Security fixes