PHP :: Bug #76660 :: Cannot connect to mysql 8 using Php 7.2.8
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:13
Avg. Score:4.9 ± 0.3
Reproduced:12 of 12 (100.0%)
Same Version:12 (100.0%)
Same OS:5 (41.7%)
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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: Frank dot Peters at mobil dot hessen dot de
New email:
PHP Version: OS:

 

 [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.
 
PHP Copyright © 2001-2018 The PHP Group
All rights reserved.
Last updated: Fri Aug 17 06:01:24 2018 UTC