phpMyAdmin 5.0 releases: remove support of old PHP versions (5.5, 5.6, 7.0, and HHVM)

by ddos ·

phpMyAdmin is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating a database, running queries, and adding user accounts.

phpmyadmin

phpMyAdmin 5.0 was released.
Changelog
  •  remove support of old PHP versions (5.5, 5.6, 7.0, and HHVM)
  • 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 shown 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 the export format is MS Excel
  • Known shortcomings:

    Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at https://github.com/phpmyadmin/phpmyadmin/issues/14220. We suggest upgrading your PHP installation to take advantage of the authentication methods.

Tags: phpMyAdmin 5.0