How to change a user password in a mysql database
January 31, 2019 by
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
about the author
Cami MacNamara is a web designer and owner of WebCami LLC, a Seattle-based agency since 2002. She created Web Designer Habits to help web designers build smarter systems, stay productive, and run a business that works for them.