How to change a user password in a mysql database

blur-brass-closed-846288

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:

  1. Login to My PHP Admin
  2. Find the users table
  3. Browser for your username
  4. Select the password file
  5. Select MD5 from the dropdown and enter your new PW
  6. 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

Cami MacNamara headshot

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.