Error Message When Resetting Admin Password

[Zebadiah Ramos]

When I attempt to reset the admin password using the below query I receive an error message stating "Error converting data type varchar to numeric". Any ideas as to what I'm doing wrong?

update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id= 'admin'

Thank you for your time, and please let me know if more information is needed!

[Nic Brough -Adaptavist-]

id is the unique id for the line in the database representing a user.  It is NOT the user's login. 

Try using lower_user_name instead of id.

[Zebadiah Ramos]

Awesome, thanks, Nic!

I used the unique id and it worked no problem.