Laravel mysql连接报错

报错：SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

软件版本

php: 7.3｜8.0
laravel/framework: 8.12
mysql: 8.0.23

问题原因

较新版本的mysql默认密码校验插件为caching_sha2_password与laravel框架内置的密码校验插件不同，导致密码验证失败

解决办法

运行sql语句，为用户设置密码插件，使用mysql_native_password密码插件校验密码

ALTER USER '用户'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
ALTER USER '用户'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;