第五章 Confluence忘记密码

一、管理员身份

#1. 进入MySql，运行此sql 找到你的管理员帐户：
root@ce9305378622:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 172585
Server version: 5.7.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| confluence         |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

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
mysql> select u.id, u.user_name, 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     | active |
+----------+---------------+--------+
|   393217 | admin         | T      |
|   393219 | zhengxue.chen | F      |
|  1703937 | yond          | T      |
| 11075586 | vicky.he      | T      |
+----------+---------------+--------+
4 rows in set (0.00 sec)

并记住管理员帐户的id


#2.  运行此sql, 恢复管理员密码为 admin
mysql> update cwd_user set credential =  
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='  
where id=xxxxxx;  

注意此处xxxxxx 为上一步的 id

如果你的密码是{PKCS5S2}前缀开头的，则用下面这个sql:
mysql> update cwd_user set credential =  
'{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF'  
where id=xxxxxx;  
 
这个管理员密码为 Ab123456

二、其他身份

请联系管理员。