Bug #99066 | Document about temporary account locking vs persistent account locking | ||
---|---|---|---|
Submitted: | 25 Mar 2020 10:25 | Modified: | 26 Mar 2020 13:15 |
Reporter: | NGUYEN TRUNG HIEU | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 8.0.19 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[25 Mar 2020 10:25]
NGUYEN TRUNG HIEU
[25 Mar 2020 11:08]
NGUYEN TRUNG HIEU
Summary: Where is failed-login tracking, account locking status for temporary account locking? What ALTER USER ... ACCOUNT UNLOCK does for temporary account unlock? --> because temporary account locking don't change account_locked:N-->Y in mysql.user Thank you for your explain!
[26 Mar 2020 13:15]
MySQL Verification Team
HI Mr. HIEU, Thank you for your report. I am not sure about your question. But. if you ask where you can track locked / unlocked account, there are two ways. One is to set verbosity level at maximum and follow the error log. The other way is to use Auditing plugins as described in the chapter 6.4.