1.用navicat连接mysql8.0报错2059,mysql8.0密码加密方式与之前不同,要么尝试更新navicat,要么修改加密方式,在mysql中输入以下代码。
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;#更新权限