Reset WordPress user password with MySQL Workbench

January 13, 2020

In category: WordPress
Tagged with: Mysql, mysql workbench, phpmyadmin

This post is more than a year old, so the information may be outdated. Just a heads up.

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 945 times, 1 visits today)

If you found this post useful ...

Wondering why you keep seeing lower-cased 'i' in my posts? Read -> Why ‘i’ is not capitalized

5 1 vote

Article Rating

0 Comments

Inline Feedbacks

View all comments

Recent Comments

Happy on How to compress + minify MailChimp’s mc-validate.js for faster loading and better PageSpeed Insight Scores: “Thank you – fantastic solution!” May 30, 15:22

Ray on How to fix a MacBook Pro keyboard and trackpad: “I love u so much this worked and I had a paper due the next day agh” May 17, 18:15

bill prusak on Delete Icon? icon\r files from your Mac: “How to delete of change file icons, mac puts a icon as part the file. Irritating!” Apr 9, 18:45

Andres on How to fix a MacBook Pro keyboard and trackpad: “Thanks! I had this issue as well. Tried everything. Until I did Keys to reset SMC ! THANKS THANKS THANKS!” Jan 18, 15:34

Rose Martine on How to choose a VPN for desktop and mobile (Android / iOS): “A fascinating discussion is definitely worth comment. I do believe that you ought to publish more on this topic, it…” Oct 19, 01:38

Happy on How to compress + minify MailChimp’s mc-validate.js for faster loading and better PageSpeed Insight Scores: “Thank you – fantastic solution!” May 30, 15:22
Ray on How to fix a MacBook Pro keyboard and trackpad: “I love u so much this worked and I had a paper due the next day agh” May 17, 18:15
bill prusak on Delete Icon? icon\r files from your Mac: “How to delete of change file icons, mac puts a icon as part the file. Irritating!” Apr 9, 18:45
Andres on How to fix a MacBook Pro keyboard and trackpad: “Thanks! I had this issue as well. Tried everything. Until I did Keys to reset SMC ! THANKS THANKS THANKS!” Jan 18, 15:34
Rose Martine on How to choose a VPN for desktop and mobile (Android / iOS): “A fascinating discussion is definitely worth comment. I do believe that you ought to publish more on this topic, it…” Oct 19, 01:38

Related

If you found this post useful ...