MySql8.0后密码认证方式问题[caching-sha2-password]

这个问题通常在laravel中表现为类似下边的异常:

local.ERROR: SQLSTATE[HY000] [2006] MySQL server has gone away {"exception":"[object] (PDOException(code: 2006): SQLSTATE[HY000] [2006] MySQL server has gone away at...

找到你的my.cnf,在[mysqld]下增加一行

 1 default-authentication-plugin=mysql_native_password 

原文地址:https://www.cnblogs.com/flydog/p/9397973.html