x2openEuler -703版本账号被锁定怎么办

现象如下:

image

解决:

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)
2 Likes

好贴必须赞一个!

此话题已在最后回复的 24 小时后被自动关闭。不再允许新回复。