|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #77113 SQLSTATE[HY000] [2054] The server requested authentication method unknown to th
Submitted: 2018-11-06 10:49 UTC Modified: -
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:
Status: Open Package: PDO MySQL
PHP Version: 7.2.11 OS: Alpine/Stretch FPM Docker image
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
Solve the problem:
43 + 50 = ?
Subscribe to this entry?

 [2018-11-06 10:49 UTC] Destroy666 at interia dot pl
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


Add a Patch

Pull Requests

Add a Pull Request


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:

This is related to commit php/php-src@d6e81f0 ( which was later reverted by php/php-src@03740ef (

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';
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Tue Oct 27 18:01:23 2020 UTC