Bug #76660 [Opn->Dup]: Cannot connect to mysql 8 using Php 7.2.8

Edit report at https://bugs.php.net/bug.php?id=76660&edit=1 ID: 76660 Updated by: nikic@php.net Reported by: Frank dot Peters at mobil dot hessen dot de Summary: Cannot connect to mysql 8 using Php 7.2.8 -Status: Open +Status: Duplicate Type: Bug Package: PDO MySQL Operating System: Windows PHP Version: 7.2.8 Block user comment: N Private report: N New Comment: caching_sha2_password support has been reverted from 7.2/7.3 shortly after, which "fixed" this issue there. The same issue for 7.4 is tracked at bug #78981. Previous Comments: ------------------------------------------------------------------------ [2018-08-20 13:13:43] danielpopiniuc at gmail dot com If I attempt to connect to MySQL 8.0.12 under Windows 10 build 1703 with either PHP 7.2.8 or 7.2.9 I get back a fatal error. But if I use another MySQL client like MySQL Workbench 8.0.12 and execute a successful query, repeating same connection attempt in same conditions it works smoothly every single time (of course, until MySQL server shuts down or restarts). From this behavior I am guessing some sort of MySQL connection initialization is not implemented properly under Windows starting with PHP 7.2.8 (still is case in 7.2.9). Hope this helps. ------------------------------------------------------------------------ [2018-08-06 21:09:20] eugene at zhegan dot in Same story here. ------------------------------------------------------------------------ [2018-07-24 12:59:11] cmb@php.net Related to bug #76651. ------------------------------------------------------------------------ [2018-07-24 11:30:13] Frank dot Peters at mobil dot hessen dot de Description: ------------ After upgrading to 7.2.8 from 7.2.7, no connection to mySql 8.0.11 can be made. Using doctrine, the Error-msg is: Type: PDOException Message: PDO::__construct(): Unexpected server respose while doing caching_sha2 auth: 109 File: C:\my_project\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php Line: 46 Downgrading to 7.2.7 solves this issue. This might be realated to Bug #76651, so in answer to the question there: SELECT @@default_authentication_plugin has the result caching_sha2_password ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=76660&edit=1