Software 42763 Published by

Isaac Bennetch has announced new versions of the MariaDB/MySQL management tool phpMyAdmin. Both versions contain several security fixes.





Hello,

The phpMyAdmin team announces the release of both 4.9.5 and 5.0.2.

Both versions contain several security fixes:

* PMASA-2020-2 SQL injection vulnerability in the user accounts page,
particularly when changing a password
* PMASA-2020-3 SQL injection vulnerability relating to the search feature
* PMASA-2020-4 SQL injection and XSS having to do with displaying results
* Removing of the "options" field for the external transformation.

We are removing the ability for users to set "options" field for the
external transformation. This must now be hard coded in the plugin file
directly (where the program is configured). This feature allows users to
pipe output directly to an executable file, however the options field
presented a security risk and we have decided to move the options to be
hard coded in the transformation plugin file. For further assistance,
please reach out to our support team through email or Github pull request.

Version 5.0.3 also contains many bug fixes:

* Fix for copying a user account
* Removed SET AUTOCOMMIT=0 from SQL export
* Fix for the display of table borders
* Fix for ENUM radio button user interface problems
* Improved the prompt for abandoning changes when no changes were made
in the SQL window
* Fix for inserting a primary key with "insert as new row"
* Fix incorrect suggested latest available version to version 5

There are many other bugs fixes, please see the ChangeLog file included
with this release for full details.

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.

As a reminder, phpMyAdmin 4.9 is in the long-term support phase where it
will only get important security fixes and critical bug fixes. Users are
suggested to migrate to version 5.0.

Downloads are available now at https://phpmyadmin.net/downloads/

For the phpMyAdmin team,
Isaac
phpMyAdmin