1 问题描述

  安装好mysql8.1,使用navicate连接,报错

Client does not support authentication protocol requested by server;

 

2 解决

1)命令行登录mysql

mysql -h localhost -P 3306 -u 用户 -p密码

 

2)执行命令

  修改加密规则

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

 

3) 再次连接

  成功