Bug #79011 [Opn]: MySQL caching_sha2_password Authentication inconsistency

Edit report at https://bugs.php.net/bug.php?id=79011&edit=1 ID: 79011 User updated by: bendix dot ohlhauser at gmail dot com Reported by: bendix dot ohlhauser at gmail dot com Summary: MySQL caching_sha2_password Authentication inconsistency Status: Open Type: Bug Package: MySQLi related Operating System: Ubuntu 18 LTS PHP Version: 7.4.1 Block user comment: N Private report: N New Comment: Image showing the issue: https://imgur.com/a/AomDhtt Previous Comments: ------------------------------------------------------------------------ [2019-12-21 03:06:48] bendix dot ohlhauser at gmail dot com Description: ------------ --- Potential security issue, not sure though --- --- Potentially issue with MySQL, instead of PHP, not sure though --- Disclaimer: This might look like user error, but most certainly is not. See: https://stackoverflow.com/questions/59432704/php-7-4-mysql-caching-sha2-password-randomly-denying-passwords MySQL caching_sha2_password is supported by PHP7.4, but it handles the passwords incorrectly. The following password via PHP: l0QDEptp*L6tNo28ey^8 Results in Access Denied. Logging in to the account via mysql shell and running it again fixed the issue. Also, removing a character fixed the issue. Regarding php.ini: opcache is enabled. Feel free to contact me for additional information. Test script: --------------- const DB_CHARSET = 'UTF8MB4'; const DB_HOST = '127.0.0.1'; const DB_USERNAME = 'test'; const DB_PASSWORD = ''; $mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME); Expected result: ---------------- Successful login Actual result: -------------- PHP Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'test'@'localhost' (using password: YES) in /db.php on line 5 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=79011&edit=1