JIRA管理员、用户密码重置

 

 

-- Jira数据库中，用户信息都存放在表 cwd_user中
-- 切换到jiar数据库
use jiradb;

-- 更改密码为sphere
update cwd_user
set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ=='
where user_name='XXXX'
;

-- 更改密码为123456
update cwd_user
set credential='{PKCS5S2}ms9AdSR9vnOXqnNdEmRG/kxRc22qTnx3Y/nwdyaNEg5/XAANouQ+akxcQbFjJiQ4'
where user_name='XXXX'
;