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'; 找到admin 的ID +--------+----------------+--------+ | id | user_name | active | +--------+----------------+--------+ | 229266 | admin | T |
confluence数据库的配置文件:# cat /var/atlassian/application-data/confluence/confluence.cfg.xml