Resetting the WCSADMIN Administrator Password

The following SQL statements can be used to reset the default “wcsadmin” account password on a developer’s toolkit, back to its default value of “wcsadmin”, assuming the following criteria have been met.

• You are using a new instance, not a migrated instance.
• You did not change the merchant key from its default value.

**Please note: After the wcsadmin user’s password has been reset, it will become expired and must be changed the next time the wcsadmin user logs on.

The SQL below is designed to be executed against a DB2 or Derby database. If using Oracle, there may be a slight difference in the SQL to be executed, and the Resetting Accounts WebSphere Commerce v7 Information Center article can help provide the proper syntax for the Oracle SQL.

-- Reset Password
UPDATE USERREG SET LOGONPASSWORD = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' WHERE LOGONID = 'wcsadmin'; 

-- Reset Salt Value
UPDATE USERREG SET SALT = 'hsdbacehyoyn' WHERE LOGONID = 'wcsadmin'; 

-- Reset Status
UPDATE USERREG SET STATUS = 1 WHERE LOGONID ='wcsadmin'; 

-- Reset Password Expired
UPDATE USERREG SET PASSWORDEXPIRED = 0 WHERE LOGONID = 'wcsadmin';