概述
因浏览器故障导致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文章来源于互联网:confluence7重置admin用户密码
