# Failed\_Login\_Attempts and Password\_lock\_Time not updating mysql.user.account\_locked column

**URL:** <https://forums.percona.com/t/failed-login-attempts-and-password-lock-time-not-updating-mysql-user-account-locked-column/25328>\
**Category:** MySQL & MariaDB\
**Created:** [September 20, 2023, 9:51pm UTC](https://forums.percona.com/t/failed-login-attempts-and-password-lock-time-not-updating-mysql-user-account-locked-column/25328 "2023-09-20T21:51:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramasamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramasamy/32/16466_2.png) [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Post date:** [September 20, 2023, 9:51pm UTC](https://forums.percona.com/t/failed-login-attempts-and-password-lock-time-not-updating-mysql-user-account-locked-column/25328/1 "2023-09-20T21:51:19Z")

</div>

In Percona MySQL 8.0.33, we enabled the following on the users  
Failed\_login\_attempts 5  
password\_lock\_time UNBOUNDED

The functionality works fine as after 5 failed attempts, it returns the error “ERROR 3955 (HY000): Access denied for user ‘abcdef’@‘localhost’. Account is blocked for unlimited day(s) (unlimited day(s) remaining) due to 5 consecutive failed logins.” But it is not updating the column account\_locked in mysql.user table.  
Also, it does not show the status in SHOW CREATE USER…

We also enabled Connection Control Plugins.

Are we missing any setup?

---

<div class="post-metadata">

**Author:** ![Ramasamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramasamy/32/16466_2.png) [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Post date:** [September 27, 2023, 7:08pm UTC](https://forums.percona.com/t/failed-login-attempts-and-password-lock-time-not-updating-mysql-user-account-locked-column/25328/2 "2023-09-27T19:08:39Z")

</div>

Any update on this is highly appreciated.