update userreg set logonpassword = '74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020'
where logonid='wcsadmin';
update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';
update userreg set status = 1 where logonid='wcsadmin';
update userreg set passwordexpired = 0 where logonid='wcsadmin';
commit;
and then login with wcsadmin / wcsadmin.
If you want the password to be set to password of somt other id
update userreg set LOGONPASSWORD =(select LOGONPASSWORD from userreg where LOGONID='testadmin') where logonid='wcsadmin'; commit;