Umbraco CMS admin password reset

Published on Thursday, 17 November 2011
aspnet mysql password sql-server

If you forgot your Umbraco admin password, use the following SQL query to reset your Umbraco admin password in SQL Server Management Studio (SSMS) or MySQL...

Reset your Umbraco password with this SQL statement (in phpMyAdmin or MySQL shell):

UPDATE UMBRACOUSER
SET userdisabled=0, userLogin='admin',
  userPassword='bnWxWyFdCueCcKrqniYK9iAS+7E='
WHERE id=0;

This query resets your password to default.

In SQL Server Management Studio, use:

-- -- UPDATE [database].[schema].[umbracoUser] set userdisabled=0, userLogin='admin', userPassword='bnWxWyFdCueCcKrqniYK9iAS+7E=' where id=0UPDATE [databasename].[dbo].[umbracoUser] set userdisabled=0, userLogin='admin', userPassword='bnWxWyFdCueCcKrqniYK9iAS+7E=' where id=0

Umbraco admin reset .NET project
Richard Soeteman created an Umbraco Admin reset project which sets the admin username to Admin and sets the password to Admin1234!. You can find the project here.

More password resets: WordPress

Oh my! Lost your WordPress password?