|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #76243 mysql 8 - new default_authentication_plugin
Submitted: 2018-04-20 09:49 UTC Modified: 2019-11-07 21:37 UTC
Avg. Score:4.7 ± 0.7
Reproduced:184 of 189 (97.4%)
Same Version:112 (60.9%)
Same OS:88 (47.8%)
From: wapinet at mail dot ru Assigned:
Status: Open Package: MySQL related
PHP Version: Irrelevant OS:
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2018-04-20 09:49 UTC] wapinet at mail dot ru
>> For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password. 
>>Clients that use an implementation of the client/server protocol other than libmysqlclient may need to be upgraded to a newer version that understands the new authentication plugin. For example, in PHP, MySQL connectivity usually is based on mysqlnd, which currently does not know about caching_sha2_password. Until an updated version of mysqlnd is available, the way to enable PHP clients to connect to MySQL 8.0 is to reconfigure the server to revert to mysql_native_password as the default authentication plugin, as previously discussed. 

so, need implement new default_authentication_plugin (caching_sha2_password).


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2018-11-08 11:53 UTC] 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

 [2019-01-22 17:08 UTC] virgofx at live dot com
Any updated on when caching_sha2_password PR can get merged? Also missing in the 7.3.x releases.
 [2019-09-04 12:00 UTC] 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-11-07 21:37 UTC]
caching_sha2_password is supported in PHP 7.4.
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Wed Nov 13 15:01:28 2019 UTC