Shulou(Shulou.com)06/01 Report--

MySQL 8.0.19 supports entering incorrect passwords for 3 times and locking accounts.

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 that the lock is permanent until it is manually unlocked.

Deliberately enter the wrong password more than 3 times, and the account is locked, as shown below:

# mysql-hlocalhost-uhechunyang-p123456789-S / tmp/mysql_hcy.sockmysql: [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.

Unlock manually:

Alter user hechunyang@'localhost' ACCOUNT UNLOCK

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.