MySQL 5.6鎖定使用者

MySQL 5.6鎖定使用者

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 標示了是否到期。

本文永久更新連結地址：