Reset WordPress user password with MySQL Workbench

Reset WordPress user password
0 0 vote
Article Rating

In case you run into an odd situation like i did where i didn’t have access to phpMyAdmin and the password reset via email wasn’t working, but i did have access to MySQL Workbench and the database, this can help you.

  • First, make sure you can connect to your WordPress database via MySQL Workbench.
  • Second, use this MD5 Hash Generator website to create a new MD5 hash of your desired password. Basically, on the site, type in “newpassword” and it’ll spit out a new MD5 Hash for you. Copy the new MD5 hash.

MD5 Hash Generator screenshot

  • In Workbench, navigate to the (default table name and field) wp_users table, then go to the desired user’s user_pass field. Replace the old MD5 hash with the new MD5 hash you copied from that website. Click ‘Apply’.

MySQL Workbench screenshot

 

And that should be it! Voila. Let me know if you have any questions. Cheers and peace

0 0 vote
Article Rating

If you found this post useful ...

Buy Me a Coffee logo
Wondering why you keep seeing lower-cased 'i' in my posts? Read -> Why ‘i’ is not capitalized
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x