Client does not support authentication protocol requested by server

navicat连接报错 Client does not support authentication protocol requested by server

安装完mysql8.0以后，利用初始密码换了个新密码
用Navicat可视化工具连接mysql报错：Client does not support authentication protocol requested by server
原因： 新旧版本mysql加密方式不同导致Navicat无法连接mysql
解决方案： 启动mysql服务之后，执行下面这行语句

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

root是用户名，localhost是本地服务器ip地址：127.0.0.1，mysql_native_password是旧的密码验证机制

执行完上面那串语句之后问题得到解决