Navicat连接Mysql报错：Client does not support authentication protocol requested by server

Navicat连接Mysql报错：

Client does not support authentication protocol requested by server

解决：

mysql> use mysql;
Database changed
mysql> alter user 'root'@'%' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

设置完成后，从新连接即可。