MYSQL ERROR 1862: Your password has expired.

原创 mysqlexpires

修改了MySQL密码,使用客户端连接的时候遇到错误:

ERROR 1862: 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,可以正常使用了。

如果觉得这对你有用,请随意赞赏,给与作者支持
评论 0
最新评论