WordPress reset password SQL – database tweaks
Today we have got a quick update for you on how to reset WordPress admin password using SQL statement. WordPress stores passwords as a
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]';
[YOUR-USER-NAME] is your WordPress username
[YOUR-NEW-PASSWORD] is your new password