Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8

Edit report at https://bugs.php.net/bug.php?id=76651&edit=1 ID: 76651 Comment by: 104979058 at qq dot com Reported by: itaylorswift365 at gmail dot com Summary: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8 Status: Assigned Type: Bug Package: MySQLi related Operating System: Debian 9.5 x64 PHP Version: 7.2.8 Assigned To: mysql Block user comment: N Private report: N New Comment: 7.3.0beta3 mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 401a40ebd5e281cf22215acdc170723a1519aaa9 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) 已经修正了的bug... Previous Comments: ------------------------------------------------------------------------ [2018-08-27 18:55:06] no at mail dot here first236108, root is already set out of the box to use the caching_sha2_password authentication provider. Anyway, messing with MySQL settings does not fix the PHP bug introduced in PHP 7.2.8. We just have to wait until the good folks from the PHP team figure what they messed up and fix. ------------------------------------------------------------------------ [2018-08-25 06:54:44] first236108 at 163 dot com Oh, I think Eugene is right. the problem is good for safety, mybe. but I use the command solve the problem: ALTER USER root@localhost IDENTIFIED WITH caching_sha2_password BY 'password'; good luck.话说，你们能看中文? 英语水平不好啊啊啊。 ------------------------------------------------------------------------ [2018-08-25 05:47:30] first236108 at 163 dot com PHP 7.3 bate2 didn't fix this too. help, I'm tired ------------------------------------------------------------------------ [2018-08-17 08:19:10] itaylorswift365 at gmail dot com PHP 7.2.9 didn't fix this. ------------------------------------------------------------------------ [2018-08-09 15:06:58] eugene at zhegan dot in Those who keep proposing to revert the authentication ciphers back to 5.7 simply don't understand what's the point or this ticket. Newer cipher has worked from 7.2.4 til 7.2.7, then it was broken in 7.2.8. Reverting to a pre-8.0 behavior isn't a long-term solution, it's almost the same as proposing to roll back to 5.1 (why the latter isn't a "solution" ?) ------------------------------------------------------------------------ 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=76651 -- Edit this bug report at https://bugs.php.net/bug.php?id=76651&edit=1