MYSQL ERROR 1862 (HY000): Your password has expired.

来源:互联网 发布:数据库日志文件清理 编辑:程序博客网 时间:2024/05/21 06:47

遇到错误:

ERROR 1862 (HY000): Your password has expired. To log in you must
change it using a client that supports expired passwords.


原因是:

MySQL 5.6 introduces password-expiration capability, to enable database administrators to expire account passwords and require users to reset their password. 


所以只需重新修改下密码即可,修改方式如下:

以root权限登录mysql:(这里我的账户是root,密码也是root)

mysql -uroot -proot

然后更改密码:

SET PASSWORD = PASSWORD('root');


OK,可以正常使用了。

2 1