Changes in phpMyAdmin 6.0

All notable changes of the phpMyAdmin 6.0 release series are documented in this file following the Keep a Changelog format.

6.0.0 (not yet released)

Added

* #17029: Enable Twig's `strict_variables` option in development environment
* #17361: Add webpack bundler
* #16500: Add paging to Routines page
* #17753: Adding `inputmode` numeric to integer fields
* #17765: Make search input field types match columns types (integer and float)
* #17809: Adds support for SHA2 function
* #18098: Added reCaptcha example for Cloudflare Turnstile
* #18223: Add a configuration option to (dis)allow shared bookmarks: `$cfg['AllowSharedBookmarks'] = true;`
* #18225: Make database and web server info separately configurable on `$cfg['ShowServerInfo']`
* #18257: Add support for theme color modes
* #17009: Implement the security header `Permissions-Policy`
* #18349: Allow rollbacking SET queries
* #18589: Add support for PSR-15 middleware
* #18649: Add color mode toggle at the top navigation bar
* #18668: Add number formatting to Total on Browse
* #18747: Add `composer.lock` to version control
* #18799: Add an user account menu button at top right
* #18812: Add role based auth for MySQL 8.x and compatibles
* #18916: Add format button to routine, event and trigger
* #18537: Add copy to clipboard for export as text
* #19287: Add optional support for binary data in database search
* #19308: Added an option in the SQL box to "Format as a single line"
* #19352: Added support for `BETWEEN` and `NOT BETWEEN` on the query generator
* #19525: Add support for `INSERT IGNORE` into for non table imports
* #19555: Add button for Copy Query in Query Generator
* #19691: Show hostname on main page
* #19751: Add Go button at the top of the insert row table
* #19812: Add show create table shortcuts when viewing tables

Changed

* #17116: Replace Change Password dialog to modal
* #17125: Replace Add Index dialog with modal
* #17127: Replace Page settings dialog with modal
* #17278: Improve NULL div design
* #17280: Improve theme card heights
* #17399: Handle connection errors with Exception instead of warnings
* #17515: Bump js-cookie version from 2.2.1 to 3.0.1
* #17561: Improve Change Password modal UI
* #17676: Extract `url.php` entry point into a route
* #17677: Extract `js/messages.php` entry point into `/messages` route
* #17801: Export page of Settings is not responsive
* #17842: Change js.cookie.js to js.cookie.min.js
* #17632: Improve tab keypress to text fields on the login form
* #18124: Invert svg gis viewer mouse wheel zoom direction
* #18136: Force a full page reload for top menu links
* #18145: Move public files to the public directory
* #18300: Convert JavaScript files to TypeScript
* #18310: Minimize form label column width in Routine, Event and Trigger modals
* #18311: Only allow resizing textarea vertically
* #18365: Change 'reCaptcha' text to 'Captcha'
* #18439: Redesign the SQL message card
* #18576: Wrap the Application::run() code with an HTTP handler
* #18652: Disable AJAX for navigation sidebar links
* #18658: Update OpenLayers
* #18703: Limit label width in create-view table
* #18512: New directory structure
* #18994: Refactor name generation of file imports
* #19110: Refactor recent/favorite tables buttons
* #19182: Refactor GIS editor modal
* #19214: Replace jqPlot library with Chart.js library
* #19294: Simplify IN, NOT IN criteria text in Query Generator
* #19327: Prevent IN / NOT IN duplicates in Query Generator
* 835fc27: Redesign the User Groups form page
* 624126e: Redesign the database and table privileges pages
* #19398: Use `application/json` instead of `text/plain` for JSON export
* #19496: Update CODE_OF_CONDUCT.md
* #19513: Hide unwanted input depending on chosen Op type in Query Generator
* #19536: Disable Search input on unary operators
* #19542: Made Search operators `= ''`/`!= ''` more obvious
* #19651: Stay the on same page when deleting a foreign key
* #19712: Import OpenLayers and Bootstrap directly using Webpack
* #19794: Use `jquery-ui-timepicker-addon.min.js` instead of `jquery-ui-timepicker-addon.js`
* #19795: Use `additional-methods.min.js` instead of `additional-methods.js`
* #19564: Update the table comment field to a textarea
* #19947: Export ODS column headers by default

Removed

* #17351: Drop `stripslashes`
* #17516: Remove `jquery-debounce-throttle` JavaScript dependency
* #17752: Remove Sodium polyfill and require the PHP sodium extension
* #18430: Remove Query-By-Example feature
* #18547: Remove support for the Recode extension
* #18587: Remove the `public/show_config_errors.php` file
* #19128: Remove the `phpmyadmin/twig-i18n-extension` package
* #19243: Bump minimum PHP version to 8.2.0
* #19408: Removed the popup that warned about having an auto-saved query
* #19409: Drop Protocol version
* #19550: Replace jQuery UI's tooltip with Bootstrap's Tooltip
* #19852: Bump Node version to 20
* #19854: Drop support for BaconQrCode v2