一、查找数据库中的管理用户名
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 |
+--------+-----------+--------+
| 229377 | admin | T |
+--------+-----------+--------+
1 row in set (0.00 sec)
二、查找数据库用户的密码加密类型和id
mysql> select id,user_name,credential from cwd_user;
+--------+---------------+---------------------------------------------------------------------------+
| id | user_name | credential |
+--------+---------------+---------------------------------------------------------------------------+
| 229377 | admin | {PKCS5S2}W+0mjJOvFRJjIl9CYbdQDWlpmPQg5o0uYW+H5gkiIja3WCGyZFDgsZTOewFpDZnN |
PKCS5S2 为加密方式
三、修改密码
mysql> update cwd_user set credential = '{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where id = 229377;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
update cwd_user set credential = '{PKCS5S2}MXjNB5hHxi9+deDSFc5zRWEDkHb/ZwdMfeH7TCYpqBCz0byNbgOSfHtxFKWOJ5bd'
这个管理员密码为 Ab123456
四、重启wiki服务
sh stop-confluence.sh
sh start-confluence.sh