Req #76243 [Opn->Csd]: mysql 8 - new default_authentication_plugin

Edit report at https://bugs.php.net/bug.php?id=76243&edit=1 ID: 76243 Updated by: nikic@php.net Reported by: wapinet at mail dot ru Summary: mysql 8 - new default_authentication_plugin -Status: Open +Status: Closed Type: Feature/Change Request Package: MySQL related PHP Version: Irrelevant -Assigned To: +Assigned To: nikic Block user comment: N Private report: N New Comment: Closing this as caching_sha2_password is in principle supported on 7.4 -- though there are a couple of different bugs that may affect it, tracked at bug #78981 and bug #79011. Previous Comments: ------------------------------------------------------------------------ [2019-12-12 12:22:47] sugajack2004 at gmail dot com This is not working for me in PHP 7.4.0 after upgrading, despite what I'm reading everywhere else online. It worked fine in PHP 7.2.8 prior to me upgrading PHP. It seems like PHP is not recognizing caching_sha2_password again. One person mentioned "possible issues" with mysqlnd in PHP 7.4.0 that could be related, but the link included from it with point 2 doesn't include the same error I have, which is the usual "authentication method unknown to the client" one. The "possible issues" reference: https://stackoverflow.com/a/59239183 When running phpinfo(), mysqlnd also doesn't list caching_sha2_password as one of its authentication plugins, unlike mysql_native_password. Not sure if this is intentional or not, but I figured it was worth noting. ------------------------------------------------------------------------ [2019-11-07 21:37:28] nikic@php.net caching_sha2_password is supported in PHP 7.4. ------------------------------------------------------------------------ [2019-09-04 12:00:24] m dot usama dot masood at gmail dot com Any news on when caching_sha2_password PR can get merged? Still missing in the 7.3.x releases. ------------------------------------------------------------------------ [2019-01-22 17:08:19] virgofx at live dot com Any updated on when caching_sha2_password PR can get merged? Also missing in the 7.3.x releases. ------------------------------------------------------------------------ [2018-11-08 11:53:38] likeboat at 163 dot com caching_sha2_password is loaded on php7.2.9 .but when i upgrade to php7.2.12 recently it missing again. any plan to fix it again for next release of 7.2.x thanks, Billy ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=76243 -- Edit this bug report at https://bugs.php.net/bug.php?id=76243&edit=1