Reset sitecore admin password to b in Sitecore 8.0 - 9.2

6/14/2019

Sometimes it's necessary to update the admin password to default one, it might be because you refreshed your local copy of the database from production or you simply lost your password.

Use this SQL command to update the default admin account to password b.

UPDATE 
    [aspnet_Membership] 
SET 
    [Password]='qOvF8m8F2IcWMvfOBjJYHmfLABc=', 
    [PasswordSalt]='OM5gu45RQuJ76itRvkSPFw==', 
    [IsApproved] = '1', 
    [IsLockedOut] = '0'
WHERE 
    UserId IN (
        SELECT UserId FROM dbo.aspnet_Users WHERE UserName = 'sitecore\Admin'
    ) 

Works in Sitecore 8, Sitecore 8.1, Sitecore 8.2, Sitecore 9, Sitecore 9.1 (All updates)