logomichael sumner
Contact
AWWWards Nominee — Michael Sumner
Special Kudos Award Badge

How to Change a WordPress User’s Password in MySQL Database

The most powerful logins you can receive are web hosting login details. Can anything get more powerful than this? ???⚡️⚡️

— Michael Sumner (@Mic_Sumner) July 13, 2019

How to Change a WordPress User’s Password in MySQL Database
Log into your web hosting control panel.
How to Change a WordPress User’s Password in MySQL Database
Locate the phpMyAdmin tool, or your database administration tool.
How to Change a WordPress User’s Password in MySQL Database
Look for the users table.
How to Change a WordPress User’s Password in MySQL Database
1. Find your database within phpMyAdmin
How to Change a WordPress User’s Password in MySQL Database
2. Find the users table
How to Change a WordPress User’s Password in MySQL Database
3. Use a new password
How to Change a WordPress User’s Password in MySQL Database
4. Set the dropdown function to MD5, click Go.
How to Change a WordPress User’s Password in MySQL Database
5. Edit the specified user row
How to Change a WordPress User’s Password in MySQL Database
Select the MD5 function to mash up the new password.
How to Change a WordPress User’s Password in MySQL Database
Test the new login details work properly! ?

Test that your password works properly.
You can now test it out in WordPress. Visit your login page and try it out for yourself!