Password recovery 3.7 and 3.8

i have 2 versions of Nopcommerce 1 live 1 for testing, i changed the administrator password a few days ago, now when i try to log in to admin area and i am being told password is wrong, I am unable to reset administrator password as i don't have access to email adress to reset but i do have access to database, any help would be appreciated.

steve

Hello Steve,

You can manually set a new password from the database.

In the Customer table set PaswordFormatId of the account to 0 and set your desired password in the Password Column.

Regards,
Stoyan

Thanks for your help all sorted now.

Steve