WebSphere Commerce 7 | User Management | Reset Password

In Development Environment, if you wanted to reset the user credentials, you can follow these steps,

Scenario - 1 (If you don't know the Merchant Key):
In local environment, if you know any user credentials (Eg: MyUser1) and need to update another user credentials (Eg: MyUser2) with the same, here is the setup of queries, you need to execute,

    update userreg set SALT = (select SALT from userreg where LOGONID = 'MyUser1') where LOGONID = 'MyUser2'
    update userreg set LOGONPASSWORD = (select LOGONPASSWORD from userreg where LOGONID = 'MyUser1') where LOGONID = 'MyUser2';
    update userreg set status = 1 where logonid = 'MyUser2';
    update userreg set passwordexpired = 0 where logonid='MyUser2'; 

Scenario - 2 (If you know the Merchant Key):
If you know merchant key and here is the procedure,

1. Run the command
    wcs_password.bat <Your required password> <Your required Salt> <Merchant Key>
   
    Eg: wcs_password.bat myPassw0rd mySalt 0123456789abcdef
   
   It will generate encrypted password,
  
    Eg: 34jmgfjspuw93rsjdfi-qua4wd
  
2. Run the following queries,
    update userreg set SALT = 'mySalt' where LOGONID = 'wcsadmin'
    update userreg set LOGONPASSWORD = '34jmgfjspuw93rsjdfi-qua4wd' where LOGONID = 'wcsadmin';
    update userreg set status = 1 where logonid = 'wcsadmin';
    update userreg set passwordexpired = 0 where logonid='wcsadmin';