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

From: Date: Tue, 24 Jul 2018 12:59:11 +0000
Subject: Bug #76660 [Opn]: Cannot connect to mysql 8 using Php 7.2.8
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-216434@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=76660&edit=1

 ID:                 76660
 Updated by:         cmb@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
 Type:               Bug
 Package:            PDO MySQL
 Operating System:   Windows
 PHP Version:        7.2.8
 Block user comment: N
 Private report:     N

 New Comment:

Related to bug #76651.


Previous Comments:
------------------------------------------------------------------------
[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

Thread (4 messages)

« previous php.bugs (#216434) next »