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 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
Leave a Reply
Want to join the discussion?Feel free to contribute!