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

From: Date: Mon, 06 Aug 2018 21:09:20 +0000
Subject: Bug #76660 [Com]: Cannot connect to mysql 8 using Php 7.2.8
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-216642@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
 Comment by:         eugene at zhegan dot in
 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:

Same story here.


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

Thread (4 messages)

« previous php.bugs (#216642) next »