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;