Reset a WordPress Password from php My Admin – Quick and dirty

While back when I wasn’t using a password manager like I am today I had a nasty habit of not remembering the password or the username or both for a particular wordpress site.

I am posting this because all of the other articles about this “trivial” task were a bit more complicated then they should.

The only way to get around this is to use a password manager like 1Password (Mac) or KeePass (PC) but if you forgot using them then you need a quick and dirty solution right there in the database.

The trick that Branko taught me is very simple:

Step 1.

Open up your php My Admin and in the wp_users table find the user you want account data changed and click on edit to start changing the account data:

wordpress user account password reset

Step 2.

To change a password it’s only needed to select the “MD5” from the user_pass drop-down menu and enter your new password the way you want to enter it when you login to the site.

worpress account data change

Step 3.

Log in with your new account data 🙂

You made it all the way down here so you must have enjoyed this post! You may also like:

Marko Martinovic, | 13

Moving Magento store to another server

Create Windows virtual hosts for your Magento projects
Nikola Stojiljkovic, | 8

Create Windows virtual hosts for your Magento projects

Nikola Stojiljkovic, | 19

Solving problems with Category tree database information


  1. from CLI
    #openssl passwd -1 123456
    #mysql -p
    connect db_wp;
    update wp_users
    set user_pass=’$1$QoGP/ZGE$UTJRa3S37hOFrashso1cy1′
    where user_login=’admin’;

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=""> <blockquote cite=""> <code> <del datetime=""> <em> <s> <strike> <strong>. You may use following syntax for source code: <pre><code>$current = "Inchoo";</code></pre>.