一、查找数据库中的管理用户名

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