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!

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Java by Example App is available at Google Play Store NOW