原因: MySQL8.0以上版本的加密方式和MySQL5.0的不一样,所以Navicat连接MySQL会报错。
1251 - Client does not support authentication protocol requested by server; consider upgrading MysQl. cdient
– 修改远程连接权限 % 可换为自己的电脑ip
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
– 修改加密方式
alter user 'root'@'%' identified with mysql_native_password by '123456';
– 成功