使用navicat 连接mysql 报错 :
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决办法:
打开终端 使用mysql uproot -p 命令连接mysql
输入以下命令
use mysql;
alter user "root"@"localhost" IDENTIFIED WITH mysql_native_password BY "你的密码";
flush privileges;
以上命令设置root用户的验证机制,设置成功后即可使用navicat连接本地的mysql数据库