jira7.2通过修改数据库的方式 重置用户密码

查看用户名对应的字段

mysql> select * from cwd_user \G
*************************** 198. row ***************************
                 ID: 10920
       directory_id: 1
          user_name: qill
    lower_user_name: qill
             active: 1
       created_date: 2021-05-25 09:52:48
       updated_date: 2021-05-25 09:52:48
         first_name: 
   lower_first_name: 
          last_name: 齐lingling
    lower_last_name: lingling
       display_name: 齐lingling
 lower_display_name: lingling
      email_address: qill@123.com
lower_email_address: qill@123.com
         CREDENTIAL: {PKCS5S2}JTmNl3RmN3efgt671Jn9BiH9/habZpKH+ZFaMllfEOUZKnZ72dYnQC
 deleted_externally: NULL
        EXTERNAL_ID: fg3496d6-7dfdg-a5e4-5b9afggce67bf
*************************** 199. row ***************************
                 ID: 10921
       directory_id: 1
          user_name: weilj
    lower_user_name: weilj
             active: 1
       created_date: 2021-05-26 14:48:08
       updated_date: 2021-05-26 14:48:08
         first_name: 
   lower_first_name: 
          last_name: 魏丽俊
    lower_last_name: 魏丽俊
       display_name: 魏丽俊
 lower_display_name: 魏丽俊
      email_address: weilj@123.com
lower_email_address: weilj@123.com
         CREDENTIAL: {PKCS5S2}iAd4ysIZHO3edmaIvJWU567ctxtkXPFR4X89dsrdCtnfN2Y
 deleted_externally: NULL
        EXTERNAL_ID: 81d7145fg94-8a09-7df90faa03b7

修改用户名密码
此密码会修改为Ab123456

update cwd_user set credential = '{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF' where user_name="name";

©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成,浏览时请结合常识与多方信息审慎甄别。
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

相关阅读更多精彩内容

友情链接更多精彩内容