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

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

Leave a Reply

avatar

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

  Subscribe  
Notify of