navicat连接mysql8 2059-Authentication plugin ‘caching_sha2_password‘ cannot be loaded

grant all on *.* to 'root'@'%';  # 授权
flush privileges;
alter user 'root'@'localhost' identified by 'your password' password expire never;  # 修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY ''your password';  # 修改密码
flush privileges;