ylrz_saas_his_scrm/scripts/fix_admin_pwd.py

# -*- coding: utf-8 -*-
import pymysql

NEW_HASH = '$2b$10$oYOABf8dAuHm1ZXFrqE4l.L1J.1wU0q07EGuYdOn.9.NirF0jXcdu'

conn = pymysql.connect(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com',
    port=27220,
    user='root',
    password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas',
    charset='utf8mb4',
    autocommit=True,
)
cur = conn.cursor()
cur.execute("SELECT password FROM sys_user WHERE user_name=%s", ('admin',))
old = cur.fetchone()
if old:
    print('old hash:', old[0][:40], '...')
else:
    print('admin user NOT FOUND!')

cur.execute("UPDATE sys_user SET password=%s WHERE user_name=%s", (NEW_HASH, 'admin'))
print('rows affected:', cur.rowcount)

# verify
cur.execute("SELECT user_name, status FROM sys_user WHERE user_name=%s", ('admin',))
row = cur.fetchone()
print('verify admin:', row)

conn.close()
print('DONE')