dev/常用SQL语句/权限相关/重置单个用户密码.sql

UPDATE auth_user SET user_password='{SSHA}Nduy1HGzOrKcYfMKBX4WXPUtVniGJ1ivCpBnhg==' WHERE user_uid='zixian-ding';
UPDATE extend_data SET extend_data_value='9310908E6EE04CB6E3D24E8ED78E7249' WHERE extend_data_sourceid=(SELECT user_id FROM auth_user WHERE user_uid='zixian-ding');