How to change a user password in a mysql database

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

About WebCami

Cami MacNamara has been designing websites since 2002 from her home office in Seattle, Washington. Her career started as a way to be a stay-at-home mom. Certification soon followed and persistence paid off. Cami has designed 500+ websites and wants to share what she learned along the way. Look for her at WordCamp Seattle. Follow: / Twitter / Instagram