Bug #78981 [Asn->Csd]: Can't connect to MySQL 8 if server's auth plugin does not match user's one

Edit report at https://bugs.php.net/bug.php?id=78981&edit=1 ID: 78981 Updated by: nikic@php.net Reported by: txigreman at hotmail dot com Summary: Can't connect to MySQL 8 if server's auth plugin does not match user's one -Status: Assigned +Status: Closed Type: Bug Package: MySQL related Operating System: Docker php:7.4-fpm image PHP Version: 7.4.0 Assigned To: nikic Block user comment: N Private report: N New Comment: This issue (and a number of other issues) should be fixed now (will be part of 7.4.2). Please report back if you still see issues with current 7.4 HEAD or the upcoming release. Previous Comments: ------------------------------------------------------------------------ [2019-12-27 15:45:33] nikic@php.net Related To: Bug #76243 ------------------------------------------------------------------------ [2019-12-27 15:36:30] nikic@php.net Related To: Bug #76660 ------------------------------------------------------------------------ [2019-12-27 13:05:10] nikic@php.net The following pull request has been associated: Patch Name: Fix caching_sha2_password auth On GitHub: https://github.com/php/php-src/pull/5034 Patch: https://github.com/php/php-src/pull/5034.patch ------------------------------------------------------------------------ [2019-12-27 12:14:09] nikic@php.net I have a patch for the auth switch -- but connections still fail after that because mysqlnd thinks it's using SSL while it's not. ------------------------------------------------------------------------ [2019-12-27 10:14:25] nikic@php.net The basic problem here is that mysqlnd_caching_sha2_handle_server_response() doesn't deal with auth switch responses. But that probably also isn't the right place to handle them, as these are not specific to the auth plugin. It also doesn't look like the code deals with a leading 1 prefix, which might account for other reported failure modes. ------------------------------------------------------------------------ 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=78981 -- Edit this bug report at https://bugs.php.net/bug.php?id=78981&edit=1