Bug #77113 [Opn->Csd]: SQLSTATE[HY000] [2054] The server requested authentication method unknown to th

From: Date: Wed, 28 Oct 2020 12:12:47 +0000
Subject: Bug #77113 [Opn->Csd]: SQLSTATE[HY000] [2054] The server requested authentication method unknown to th
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-229978@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=77113&edit=1

 ID:                 77113
 Updated by:         nikic@php.net
 Reported by:        Destroy666 at interia dot pl
 Summary:            SQLSTATE[HY000] [2054] The server requested
                     authentication method unknown to th
-Status:             Open
+Status:             Closed
 Type:               Bug
 Package:            PDO MySQL
 Operating System:   Alpine/Stretch FPM Docker image
 PHP Version:        7.2.11
-Assigned To:        
+Assigned To:        nikic
 Block user comment: N
 Private report:     N

 New Comment:

Support for caching_sha2_password auth has re-landed in PHP 7.4, so this issue should be resolved
since then.


Previous Comments:
------------------------------------------------------------------------
[2018-11-18 17:46:35] 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';

------------------------------------------------------------------------
[2018-11-16 17:12:02] 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-06 10:49:15] 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


------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=77113&edit=1

Thread (4 messages)

« previous php.bugs (#229978) next »