查看用户名对应的字段
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";