MD5 encrypted password in database reset

If you accidentally change the password of the project administrator account and forget, there is a password in the database is MD5 encrypted, how to do?

1. Oracle database, can be used Dbms_obfuscation_toolkit. MD5 (Input + = Utl_raw.cast_to_raw (' preset password ')) to obtain a password that is MD5 encrypted:

SQL is as follows:

-----The MD5 value obtained here is uppercase, if the database is stored in lowercase, you need to use the lower function to convert it.

Update Web_org_oper O
Set o.c_passwd = Lower (Dbms_obfuscation_toolkit. MD5 (input = Utl_raw.cast_to_raw (' 11 ')))
where c_oper_id = ' 02000001 ';

2. Mysql,sql server database, have built-in MD5 () function, (SQL Server, should be hashbyte (' encryption method ', ' value to be encrypted '),

For information on how to use functions, the stored procedure implementation is supplemented later

MD5 encrypted password in database reset