Simple, free resources to help you build a better WordPress website.

Sign up for our newsletter.

Reset your WordPress password via phpMyAdmin

This is an easy trick to reset your password without having to go through the email reset process which can be a bit shaky at times. Here’s how I do it via phpMyAdmin.

1. Select and edit the user row in question from the *_users table

2. Select MD5 from the Function dropdown in the user_pass row

3. Input a normal text password

4. Upon saving, you should see the new password hash

2 Comments

  1. Avatar
    yatramantra says:

    Thanks for this post.But when i tring to modify the the password it updated well but can’t login.Actually i imported the sql file from live server to localhost.I dont know what was went wrong 🙁

  2. Avatar

    Respected Sir,

    You are my God sent Messiah, who saved me tonnes of hours that I would have otherwise spent in resetting my password and recovering my username.

    Many thanks from the bottom of my heart.

Leave a Reply

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