We’ve all been there, we’ve set-up a website for the first time, added in the admin details and password, attempt to log-in only to realise you have mistyped the password or just plain forgotten it. In today’s guide, I’m going to cover how you can reset your database Umraco 7 password in SQL.
The first thing you will need to do, is open SQL manager and find the ‘umbracoUser’ table:
In the table, find the user account you want to reset and make a note of the Id property for the account you want to update. When you look at the screenshot, you should notice that the password has been hashed for security reasons. The password is stored as a hash for security so we cannot just simply type in any old password in plain text and expect it to work. Instead, we need to know the hashed code for some common passwords, luckily I have several examples we can use, these are:
userPassword Value : /7IIcyNxAts3fvQYe2PI3d19cDU= Password : password
userPassword Value : d9xnUXsUah9gycu7D0TpRYcx19c= Password : admin
userPassword Value : bnWxWyFdCueCcKrqniYK9iAS+7E= Password : default
Pick any of the ‘userPassword’ values above and then run the following SQL command:
UPDATE umbracoUser set userdisabled=0, userPassword='/7IIcyNxAts3fvQYe2PI3d19cDU=' where id=0
Change the id value to the number of the user account you want to update. Now, when you try to log back-into Umbraco, you should be able to log-in with your username and the password for the hash that you picked, from the example above, this will be password.