Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8

From:	brayamrivas at gmail dot com	Date:	Fri, 27 Jul 2018 15:44:59 +0000
Subject:	Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-216505@lists.php.net to get a copy of this message

Edit report at https://bugs.php.net/bug.php?id=76651&edit=1

 ID:                 76651
 Comment by:         brayamrivas at gmail dot com
 Reported by:        itaylorswift365 at gmail dot com
 Summary:            Can't establish a connection to MySQL after
                     upgrading PHP from 7.2.7 to 7.2.8
 Status:             Assigned
 Type:               Bug
 Package:            MySQLi related
 Operating System:   Debian 9.5 x64
 PHP Version:        7.2.8
 Assigned To:        mysql
 Block user comment: N
 Private report:     N

 New Comment:

Hi guys,

You can try to add this line into /etc/my.cnf (Systems based on Linux OS):

default-authentication-plugin=mysql_native_password


Then, restart mysqld proccess. 

This works for me. I'm using Laravel 5.5.

Best regards,
BR


Previous Comments:
------------------------------------------------------------------------
[2018-07-26 20:30:08] amenshchikov at gmail dot com

I had the same problem and solved it by changing password for MySQL user without
'mysql_native_password' plugin:
  ALTER USER 'user'@'localhost' IDENTIFIED BY 'password';

But I was forced to use password with max lenght of 16 chars, otherwise I was getting the connection
error.

------------------------------------------------------------------------
[2018-07-24 14:25:44] itaylorswift365 at gmail dot com

MySQL Version: 8.0.11 
Value of SELECT @@default_authebticatiin_plugin is "caching_sha2_password"

------------------------------------------------------------------------
[2018-07-24 12:59:11] cmb@php.net

Related To: Bug #76660

------------------------------------------------------------------------
[2018-07-23 15:09:11] johannes@php.net

Which MySQL server version are you using? Whats the value of SELECT
@@default_authebticatiin_plugin?

------------------------------------------------------------------------
[2018-07-22 01:16:16] no at mail dot here

This bug also crops up on PHP 7.2.8 for Windows (x86 and x64). phpMyAdmin is affected as well.

------------------------------------------------------------------------


The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at

    https://bugs.php.net/bug.php?id=76651


--
Edit this bug report at https://bugs.php.net/bug.php?id=76651&edit=1


   

Thread (22 messages)

• itaylorswift365 at gmail dot comSat, 21 Jul 2018 18:26:52 +0000
  • itaylorswift365 at gmail dot comSat, 21 Jul 2018 18:30:10 +0000Bug #76651 [Opn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • no at mail dot hereSun, 22 Jul 2018 01:16:16 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • johannes@php.netMon, 23 Jul 2018 15:09:11 +0000Bug #76651 [Opn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • itaylorswift365 at gmail dot comTue, 24 Jul 2018 14:25:44 +0000Bug #76651 [Asn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • amenshchikov at gmail dot comThu, 26 Jul 2018 20:30:08 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • brayamrivas at gmail dot comFri, 27 Jul 2018 15:44:59 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • no at mail dot hereSat, 28 Jul 2018 07:00:21 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • theodorejb at outlook dot comSun, 05 Aug 2018 19:41:54 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • eugene at zhegan dot inMon, 06 Aug 2018 21:10:33 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • thaddee at bechtold dot meTue, 07 Aug 2018 07:39:38 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • eugene at zhegan dot inThu, 09 Aug 2018 15:06:58 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • 104979058 at qq dot comFri, 31 Aug 2018 02:06:46 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • 104979058 at qq dot comMon, 03 Sep 2018 01:19:23 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • nikic@php.netTue, 04 Sep 2018 04:05:40 +0000Bug #76651 [Asn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • johannes@php.netTue, 04 Sep 2018 09:33:54 +0000Bug #76651 [Asn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • nikic@php.netTue, 04 Sep 2018 13:29:41 +0000Bug #76651 [Asn]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • no at mail dot herThu, 06 Sep 2018 08:06:28 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • cmb@php.netMon, 10 Sep 2018 18:11:42 +0000Bug #76651 [Asn->Csd]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • no at mail dot hereFri, 14 Sep 2018 18:53:08 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • nikic@php.netSun, 16 Sep 2018 06:44:05 +0000Bug #76651 [Csd]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8
  • no at mail dot hereSun, 16 Sep 2018 09:23:20 +0000Bug #76651 [Com]: Can't establish a connection to MySQL after upgrading PHP from 7.2.7 to 7.2.8