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)
设置完成后,从新连接即可。