use confluence;
select u.id ,u.user_name, u.active from cwd_user u
join cwd_membership cm on u.id = cm.child_user_id
join cwd_group cg on cm.parent_id = cg.id
join cwd_directory cd on cg.directory_id = cd.id
where cg.group_name = 'confluence-administrators' and cd.directory_name='Confluence Internal Directory';

update cwd_user set credential = '{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where id=229377;

###恢复密码为admin
update cwd_user set credential =  'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='  where id=xxxxxx;