1862-your password has expired. To log in you must change it using a client that supports expired passwords.问题解决

  今天连接mysql报出如下错误:

原因:

  密码过期无法登陆

解决办法:

  mysql -h localhost -u root -p (连接mysql服务器)

  SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');(重新修改root密码)

  ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;(不验证有效期)

  之后删除Navicat里的连接新建连接即可。

原文地址:https://www.cnblogs.com/jmdd/p/11922966.html