Reset WordPress user password with MySQL Workbench

Reset WordPress user password

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

(Visited 1,071 times, 1 visits today)

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
5 1 vote
Article Rating
Subscribe
Notify of
guest

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