Ubuntu下连接数据库失败_没有五分仪_新浪博客

错误信息msg:Client does not support authentication protocol requested by server; consider upgrading MySQL client,sqlstate:08004

mysql 版本：5.7

解决办法

1.mysql -uroot -ppwd

2. ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

3. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yournewpassword'

4.flush privileges;