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?