现象如下:
解决:
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| x2openEulerDb |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> use x2openEulerDb;
MariaDB [x2openEulerDb]> select * from usermanager_lockedip;
+----+----------------------------+---------------+-------------+
| id | time_failedlogin | ipaddr | lock_status |
+----+----------------------------+---------------+-------------+
| 3 | 2023-08-11 16:54:58.056365 | 192.168.137.1 | 1 |
| 4 | 2023-08-11 16:55:03.306385 | 192.168.137.1 | 1 |
+----+----------------------------+---------------+-------------+
###### 这里的 192.168.137.1 就是被锁定的登陆ip #########
MariaDB [x2openEulerDb]> delete from usermanager_lockedip where ipaddr="192.168.137.1";
Query OK, 10 rows affected (0.00 sec)