php.net |  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
Votes:205
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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: wapinet at mail dot ru
New email:
PHP Version: OS:

 

 [2018-04-20 09:49 UTC] wapinet at mail dot ru
Description:
------------
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password
>> 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).


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

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

thanks,
Billy
 [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] nikic@php.net
caching_sha2_password is supported in PHP 7.4.
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Thu Nov 14 06:01:35 2019 UTC