navicat for mysql 链接时报错：1251-Client does not support authentication protocol requested by serve...

navicat for mysql 链接时报错：1251-Client does not support authentication protocol requested by serve

解决方法：

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

 mysql> select host,user,plugin,authentication_string from mysql.user;

 

转载于:https://www.cnblogs.com/Dev0ps/p/10424854.html