MySQL8.0踩坑记录

1.PHP错误：SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

error.jpg

解决方法1:

修改  /etc/my.cnf，在mysqld下添加

default_authentication_plugin=mysql_native_password

解决方法2:

修改密码认证方式

ALTER USER 'YOURUSERNAME'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOURPASSWORD';

FLUSH PRIVILEGES;

quit;