Reset Your Umbraco 7 Password Manually via the database

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.

SQL Manager

The first thing you will need to do, is open SQL manager and find the 'umbracoUser' table: umbraco_changing_passwords 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.


Jon D Jones

Software Architect, Programmer and Technologist Jon Jones is founder and CEO of London-based tech firm Digital Prompt. He has been working in the field for nearly a decade, specializing in new technologies and technical solution research in the web business. A passionate blogger by heart , speaker & consultant from England.. always on the hunt for the next challenge


Back to top
var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-35662136-1']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + 'stats.g.doubleclick.net/dc.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })();