共计 676 个字符,预计需要花费 2 分钟才能阅读完成。
MySQL 5.7 加入了 LOCK ACCOUNT 功能和 Oracle 一样了,但是 MySQL 5.6 貌似没有,但是可以代替用如下方法设置密码过期。
The mysql.usertable now has a password_expiredcolumn. Its default value is ‘N’, but
can be set to ‘Y’with the new ALTER USER statement. After an account’s password has been
expired, all operations performed in subsequent connections to the server using the account result
in an error until the user issues a SET PASSWORDstatement to establish a new account password.
For more information, see Section 13.7.1.1,“ALTER USERSyntax”, and Section 6.3.6,“Password
Expiration and Sandbox Mode”.
就是下面这个语法
mysql> alter user mytest1@’%’ password expire;
如果要恢复
set password for mytest1@’%’ = ‘*******’;
其实就是 MYSQL.USER 下面的字段 password_expired 标示了是否过期。
本文永久更新链接地址 :http://www.linuxidc.com/Linux/2016-07/133394.htm
![post-qrcode](https://www.xgss.net/wp-content/uploads/2023/07/二维码-微信公众号256x256.jpg)