How to change a user password in a mysql database
January 31, 2019 /
One of the most frustrating things I remember about learning WordPress was losing my own password and not getting the password reset emails. I couldn’t log into the site, so I was stuck not knowing how in the world I would get in. A few Google searches lead to instructions.
Here’s a quick video:
- Login to My PHP Admin
- Find the users table
- Browser for your username
- Select the password file
- Select MD5 from the dropdown and enter your new PW
- Save
Always remember to back everything up before you dive in! How much work do you do in the database?
RESOURCES: Cybersecurity 101: Why you need to use a password manager