1251-Client does not support authentication protocol requested by server

一个值得参考的navicat for mysql 链接时报错:1251-Client does not support authentication protocol requested by server

最近叕开始折腾数据了,在Navicat for MySQL连接MySQL数据库时报了如题的错误,经过各种采坑,终于解决了,注意我这里是用的MySQL8.0社区办,和Navicat for MySQL11.1.13企业版,解决方案如下:
1.打开如下图1所示两个中 的任意一个,然后输入密码,如图2所示。1251-Client does not support authentication protocol requested by server1251-Client does not support authentication protocol requested by server
2.输入
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;

回车
3.再输入
FLUSH PRIVILEGES;
回车

完成
注意:别忘记了SQL后面的分号,句子原样拷贝下来就行了。