php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #76660 Cannot connect to mysql 8 using Php 7.2.8
Submitted: 2018-07-24 11:30 UTC Modified: 2018-07-24 12:59 UTC
Votes:21
Avg. Score:5.0 ± 0.2
Reproduced:20 of 20 (100.0%)
Same Version:20 (100.0%)
Same OS:10 (50.0%)
From: Frank dot Peters at mobil dot hessen dot de Assigned:
Status: Open Package: PDO MySQL
PHP Version: 7.2.8 OS: Windows
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [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

Add a Patch

Pull Requests

Add a Pull Request

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.
 
PHP Copyright © 2001-2018 The PHP Group
All rights reserved.
Last updated: Tue Oct 16 15:01:25 2018 UTC