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

Cami MacNamara has 20+ years of experience running a small, profitable, one-person web design business, so she can walk her dog whenever she likes. WebCami.com / Twitter / Instagram