tdsql登录失败5次,锁24小时的 解决办法

tdsql使用过程中, 难免会遇到控制台锁了的情况. (密码太简单不安全, 太复杂容易输错, 记住密码也不安全...)

报错

登陆失败5次以上，账号已锁，24小时内无法再次登陆，如需解锁，请联系管理员

解决办法(过程)

获取配置库信息(可选)

如果有配置库的信息就可以跳过这一步.

使用如下命令(也可以在浏览器上打开)获取配置库IP,端口,账号和密码

注意: 把IP换成你自己控制台的IP

<code style="margin-left:0">[root@tdsql01 ~]# curl http://192.168.101.101/tdsqlpcloud/index.php/api/install/get_db_info
{"ip":"192.168.101.102","port":"15001","user":"tdsqlpcloud","pwd":"123456"}</code>

得到配置库信息

登录控制台 找到锁相关的表(可选)

本教程已经找到了, 但是还是再找一遍

登录配置库.

<code style="margin-left:0">[root@tdsql02 ~]# <a href="https://www.mhzhuji.com/kwck/57"  class="lar_link lar_link_outgoing" data-linkid="219" data-postid="1438"  title="数据库MySQL"  rel="nofollow" target="_blank" >mysql</a> -h192.168.101.102 -utdsqlpcloud -P15001 -p123456
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your <a href="https://www.mhzhuji.com/kwck/57"  class="lar_link lar_link_outgoing" data-linkid="219" data-postid="1438"  title="数据库MySQL"  rel="nofollow" target="_blank" >MySQL</a> connection id is 9152
Server version: 5.7.33-V2.0R681D005-v17-20210125-2105-log Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

<a href="https://www.mhzhuji.com/kwck/57"  class="lar_link lar_link_outgoing" data-linkid="219" data-postid="1438"  title="数据库MySQL"  rel="nofollow" target="_blank" >MySQL</a> [(none)]> select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from information_schema.COLUMNS where COLUMN_NAME like '%lock%' and TABLE_SCHEMA='tdsqlpcloud';
+--------------+----------------+--------------+
| TABLE_SCHEMA | TABLE_NAME     | COLUMN_NAME  |
+--------------+----------------+--------------+
| tdsqlpcloud  | t_dbuser_apply | locked       |
| tdsqlpcloud  | t_sys_login    | failure_lock |
| tdsqlpcloud  | t_sys_workflow | wf_locked    |
+--------------+----------------+--------------+
3 rows in set (0.03 sec)

MySQL [(none)]> select * from tdsqlpcloud.t_sys_login;
+-----------+---------------+---------------------+--------------+
| user_name | failure_count | failure_mtime       | failure_lock |
+-----------+---------------+---------------------+--------------+
| admin     |             5 | 2022-11-07 19:18:13 |            1 |
+-----------+---------------+---------------------+--------------+
1 row in set (0.01 sec)

MySQL [(none)]> </code>

发现 tdsqlpcloud.t_sys_login 表的failure_lock字段是1, 就是锁了的意思(默认0, 不锁)

注:可以使用 show create table tdsqlpcloud.t_sys_login; 查看表DDL, 一般都有注释的.

解决办法

把tdsqlpcloud.t_sys_login 表的failure_lock字段改为0

sql: update tdsqlpcloud.t_sys_login set failure_lock = 0 where user_name='admin';

<code style="margin-left:0">MySQL [(none)]> select * from tdsqlpcloud.t_sys_login;
+-----------+---------------+---------------------+--------------+
| user_name | failure_count | failure_mtime       | failure_lock |
+-----------+---------------+---------------------+--------------+
| admin     |             5 | 2022-11-07 19:18:13 |            1 |
+-----------+---------------+---------------------+--------------+
1 row in set (0.00 sec)

MySQL [(none)]> update tdsqlpcloud.t_sys_login set failure_lock = 0 where user_name='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MySQL [(none)]></code>

验证

登录成功

未经允许不得转载：木盒主机 » tdsql登录失败5次,锁24小时的 解决办法