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

1 Comment

  1. 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 🙁

Leave a Reply

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