[root@gitlab ~]# cat /etc/gitlab/initial_root_password # WARNING: This value is valid only in the following conditions # 1. If provided manually (either via `GITLAB_ROOT_PASSWORD` environment variable or via `gitlab_rails['initial_root_password']` setting in `gitlab.rb`, it was provided before database was seeded for the first time (usually, the first reconfigure run). # 2. Password hasn't been changed manually, either via UI or via command line. # # If the password shown here doesn't work, you must reset the admin password following https://docs.gitlab.com/ee/security/reset_user_password.html#reset-your-root-password.
mysql -uroot -pRadBank@530 show databases; use confluence; select id,user_name,active,email_address,credential from cwd_user;
-- 在数据库里面查看管理员用户 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';
-- 无{PKCS5S2}的,更改密码为sphere update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX';
-- 有{PKCS5S2}的,更改密码为123456 update cwd_user set credential='{PKCS5S2}ms9AdSR9vnOXqnNdEmRG/kxRc22qTnx3Y/nwdyaNEg5/XAANouQ+akxcQbFjJiQ4' where user_name='XXXX';
-- 密码是{PKCS5S2}前缀开头的,则用下面这个sql,这个管理员密码为 Ab123456 update cwd_user set credential='{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where id=xxxxxx;
mysql -uroot -pRadBank@530 show databases; -- Jira数据库中,用户信息都存放在表 cwd_user中 -- 切换到jiar数据库 -- CREDENTIAL字段是加密后的密码 use jiradb; -- 看看管理员用户信息,待会会用到 select id,user_name,active,email_address,credential from cwd_user;
-- 无{PKCS5S2}的,更改密码为sphere update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX';
-- 有{PKCS5S2}的,更改密码为123456 update cwd_user set credential='{PKCS5S2}ms9AdSR9vnOXqnNdEmRG/kxRc22qTnx3Y/nwdyaNEg5/XAANouQ+akxcQbFjJiQ4' where user_name='XXXX';
-- 有{PKCS5S2}的,更改密码为Ab123456 update cwd_user set credential='{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where id=xxxxxx;
-- 最后记得复原密码 update cwd_user set credential='初始密码' where user_name='XXXX';