confluence7重置admin用户密码

概述

因浏览器故障导致confluence的保存密码均丢失，由于未对密码进行备份导致无法恢复。

操作步骤

需要重置admin用户密码为admin2022cp

进入数据库

使用数据库root或confluence运行时配置的用户进入。

mysql> use confluence;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

查询用户ID

查询管理用户的id

mysql> select u.id, u.user_name,u.credential,u.active from cwd_user u join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';
+--------+------------+---------------------------------------------------------------------------+--------+
| id     | user_name  | credential                                                                | active |
+--------+------------+---------------------------------------------------------------------------+--------+
| 229377 | admin      | {PKCS5S2}3TTGds/qSA1iRSQEgpKAftp0xYTOQSlNHc6lLhM+OBGaWHsrOOEQqUxiBjJKzh3u | T      |
+--------+------------+---------------------------------------------------------------------------+--------+
1 rows in set (0.00 sec)

重置密码

根据admin查询到的用户ID进行修改，密码修改为admin2022cp。

mysql> update cwd_user set credential = '{PKCS5S2}qmpTl+q+t5eS5MQOYbDa2spkPRIGhH92qcgYqEjHLVM5Rzxd0tCvI4WZBfUQo60V' where id=229377;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

END