Home Feature Posts How to reset Umbraco Admin Account Password | User Guide

How to reset Umbraco Admin Account Password | User Guide

by Wikky
1138 views
how-to-reset-umbraco-admin-password
how-to-reset-umbraco-admin-password

You forgot your administrator password and you need to make urgent changes in your Umbraco website. If your Umbraco application is up and running on any server (localhost, staging/production environment), so don’t need to waste your time by trying wrong password and get frustrated. All you need to follow below steps to reset your Umbraco admin password. Using the same method you can also reset any of the registered user’s password by knowing its record id stored in “umbracouser” database table.

Step 1: Update User Password using SQL Server Management Studio (SSMS)

Open SQL Server Management Studio (SSMS)

Login to your SQL server instance

Browse databases and Select your Umbraco Database by Single Click on it.

Click on create new query icon from tool menu to open new query window

Run the following SQL Command into new query window:run

UPDATE umbracoUser SET userdisabled = 0, userLogin = 'admin',
userPassword = 'default' WHERE id = 0

This will set your admin account to enable and the password to “default”.

Umbraco is saving user passwords in umbracouser table using hashed encryption technique, so you need to make temporary edits for some settings regarding user management in web.config file.

Step 2: Update Web.Config file from root directory

Open your Web.config from root level directory, and search for UsersMembershipProvider

You will find the passwordFormat property value is set to “Hashed”. You need to update it to “Clear” so that you can login.

Save the web.config file.

Step 3: Log in to Umbraco and update new password

Now Go to umbraco login page and provide your username “xyz” and the password “default” and click on Login.

Boom! You find your user is logged in now.

Update the password from “default”  to some other as you want for your admin user account from front-end UI.

Step 4: Revert back web.config changes to default

Once you update your password from UI, you need to revert your web.config file changes back to “Hashed” from “Clear” and Save web.config.

Now your password will be saved in the database using hashed encryption technique instead of clear text.

It is very important to verify your password is saved in hashed value to follow security and privacy standards that you have updated from UI, you need to run the below SQL query:

SELECT userName, userPassword FROM umbracoUser WHERE id = 0

You will get result of admin user and check the password is stored in hashed format.

Hope this will help! 

You may also like

5 comments

Configuration March 29, 2021 - 11:59 am

Fresh

Reply
Wikky April 10, 2021 - 5:47 am

(Y)

Reply
Legacy April 8, 2021 - 7:36 am

Strategist

Reply
Wikky April 10, 2021 - 5:51 am

(Y)

Reply
Refined May 16, 2021 - 4:15 pm

synthesize

Reply

Leave a Comment

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More