MySQL 8.0.19 supports locking an account after entering an incorrect password three times (example)

MySQL 8.0.19 supports locking the account after entering the wrong password three times

example:

>CREATE USER 'hechunyang'@'localhost' IDENTIFIED BY '123456' FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 3;

FAILED_LOGIN_ATTEMPTS: represents the number of failed attempts

PASSWORD_LOCK_TIME: represents the lock time, in days. Here it is locked for 3 days.

If UNBOUNDED is set, it means the lock is permanent until manually unlocked.

If you intentionally enter the wrong password more than 3 times, your account will be locked as shown below:

# mysql -hlocalhost -uhechunyang -p123456789 -S /tmp/mysql_hcy.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3955 (HY000): Access denied for user 'hechunyang'@'localhost'.
Account is blocked for 3 day(s) (3 day(s) remaining) due to 3 consecutive failed logins.

ps: Let's take a look at the mysql 8.0.19 update unable to log in problem

cd /usr/local//mysql/bin
mysqld --initialize --console

Don't panic when reporting errors

/usr/local/var/mysql 刪除里面的文件

Initial setup here

mysqld --initialize --console

You will get a temporary password

mysql -uroot -p Change password after login

alter user 'root'@'localhost' identified by '123456';

Summarize

The above is the editor's introduction to the MySQL 8.0.19 support for locking the account after entering the wrong password three times. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!