WorkBench问题

问题一：

 { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

 原因：登录数据库的客户端跟mysql8.0不兼容了，mysql8.0密码认证采用了新的密码格式

 解决：进入当前数据库执行以下代码

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

 

posted @ 2020-06-08 17:22  “匆匆”  阅读(139)  评论(0)  编辑  收藏  举报