navcat 链接mysql 报 2059错误解决方案

切到mysql数据库

select user,host from user;

查看root用户对应的数据，所有的root的用户对应的host都要执行修改语句

ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'rootroot123';

和
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'rootroot123';