WordPress reset password SQL – database tweaks

• Tweet

• Tweet

Today we have got a quick update for you on how to reset WordPress admin password using SQL statement. WordPress stores passwords as a MD5 hash.
Log in to your wordpress database and execute the following SQL statement.

UPDATE wp_users SET user_pass=MD5('[YOUR-NEW-PASSWORD]') WHERE user_login='[YOUR-USER-NAME]';

where
[YOUR-USER-NAME] is your WordPress username
[YOUR-NEW-PASSWORD] is your new password