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

More Posts

6 replies
  1. Dave
    Dave says:

    Hi – Thanks for posting. How did you compute those hashes? I’d read that it was HMACSHA1 with the password as both the key and value. Couldn’t replicate these hashes. Thanks for your help!

    Reply
    • Jon D Jones
      Jon D Jones says:

      I set the password on the admin account to something I knew, then copied the hash directly from SQL. As all Umbraco sites will start off with the default database (that has the admin account), using those hashes works for the majority of people 🙂

      Reply
      • Dave
        Dave says:

        Thanks for your reply. I just didn’t realize it was saved as a base64 string, which seems obvious now. Here’s a method to generate passwords to update Umbraco user records with in a pinch.
        public static string GetHash(string password)
        {
        byte[] passwordBytes = System.Text.Encoding.Unicode.GetBytes(password);
        using(var hash = new System.Security.Cryptography.HMACSHA1(passwordBytes))
        {
        return Convert.ToBase64String(hash.ComputeHash(passwordBytes));
        }
        }

        Reply

Trackbacks & Pingbacks

  1. […] Enter your Umbraco username and password (the one you wrote down during the installation section) then press login. If you have forgotten your password I recommend reading Reset Your Umbraco 7 Password Manually via the database […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *