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=0
UPDATE [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?

This may interest you:   PowerShell return value, exit code, or ErrorLevel equivalent