php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #77113 SQLSTATE[HY000] [2054] The server requested authentication method unknown to th
Submitted: 2018-11-06 10:49 UTC Modified: 2020-10-28 12:12 UTC
Votes:12
Avg. Score:4.5 ± 0.8
Reproduced:12 of 12 (100.0%)
Same Version:6 (50.0%)
Same OS:1 (8.3%)
From: Destroy666 at interia dot pl Assigned: nikic (profile)
Status: Closed Package: PDO MySQL
PHP Version: 7.2.11 OS: Alpine/Stretch FPM Docker image
Private report: No CVE-ID: None
View Developer Edit
 [2018-11-06 10:49 UTC] Destroy666 at interia dot pl 
Description:
------------
In versions 7.2.4-7.2.10 the connection worked fine, but after upgrading I get the authentication method error that existed in earlier versions that didn't support MySQL 8 again.

Expected result:
----------------
The PDO authentication method should work correctly with MySQL 8.

Actual result:
--------------
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-11-16 17:12 UTC] nog76 at gmx dot de 
I have exact the same issue, but running on Debian 9.6
After upgrading from PHP 7.2.10 to 7.2.11 most of my applications are getting this error message.
Btw. same behaviour with PHP 7.2.12
 [2018-11-18 17:46 UTC] nog76 at gmx dot de 
Found the reason here:
https://github.com/phpmyadmin/phpmyadmin/issues/14220

This is related to commit php/php-src@d6e81f0 (https://github.com/php/php-src/commit/d6e81f0bfd0cb90586dd83d4fd47a4302605261a) which was later reverted by php/php-src@03740ef (https://github.com/php/php-src/commit/03740ef7dffcc80530a89ebde3ccf5464f7f18e6).

So the current workaround is to change back all mysql-database-passwords to mysql_native_password:
ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';
 [2020-10-28 12:12 UTC] nikic@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: nikic
 [2020-10-28 12:12 UTC] nikic@php.net 
Support for caching_sha2_password auth has re-landed in PHP 7.4, so this issue should be resolved since then.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Nov 21 20:01:29 2024 UTC