修改账户密码加密规则并更新用户密码

 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER;   //修改加密规则 

 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘password‘;   //更新一下用户的密码 

刷新权限

FLUSH PRIVILEGES;  //刷新权限 

重置密码

alter user ‘root‘@‘localhost‘ identified by ‘369258‘;  //重置下密码

关闭navicat premium重新打开连接

特别感谢写这个博客的人valiant_勇哥

Ubuntu下mysql连接Navicat premium报错