php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Thanks for voting! Your vote should be reflected in the statistics below.
Bug #76660 Cannot connect to mysql 8 using Php 7.2.8
Submitted: 2018-07-24 11:30 UTC Modified: 2019-12-27 15:36 UTC
Votes:34
Avg. Score:4.9 ± 0.4
Reproduced:30 of 31 (96.8%)
Same Version:25 (83.3%)
Same OS:17 (56.7%)
From: Frank dot Peters at mobil dot hessen dot de Assigned:
Status: Duplicate Package: PDO MySQL
PHP Version: 7.2.8 OS: Windows
Private report: No CVE-ID: None
View Developer Edit
 [2018-07-24 11:30 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-07-24 12:59 UTC] cmb@php.net 
Related to bug #76651.
 [2018-08-06 21:09 UTC] eugene at zhegan dot in 
Same story here.
 [2018-08-20 13:13 UTC] 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.
 [2019-12-27 15:36 UTC] nikic@php.net
-Status: Open +Status: Duplicate
 [2019-12-27 15:36 UTC] nikic@php.net 
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.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Apr 01 22:01:29 2025 UTC