Navicat 1251-Client does not support authentication protocol requested by server；

Navicat 连接数据库报错

1251-Client does not support authentication protocol requested by server；

原因：
高版本Mysql加密方式为 caching_sha2_password
Navicat支持的加密方式为 mysql_native_password

mysql> use mysql
Database changed
mysql> select user,plugin from user;
+------------------+-----------------------+
| user             | plugin                |
+------------------+-----------------------+
| root             | caching_sha2_password |
| xue              | mysql_native_password |
| mysql.infoschema | caching_sha2_password |
| mysql.session    | caching_sha2_password |
| mysql.sys        | caching_sha2_password |
| root             | caching_sha2_password |
+------------------+-----------------------+
6 rows in set (0.00 sec)

此处可见我已经新建了一个远程用户连接，加密方式为 mysql_native_password

新建远程用户：

mysql> create user 'xue'@'%' identified with mysql_native_password by '你的密码';
Query OK, 0 rows affected (0.01 sec)

mysql> grant all privileges on *.* to 'xue'@'%';
Query OK, 0 rows affected (0.00 sec)

Navicat连接时使用你新建的用户名密码即可。
也可直接更改root用户的加密方式用root用户连接。