There are times when you forget your WordPress password, one of the easiest ways to reset your WordPress password is by using phpMyAdmin. You might be wondering what is phpMyAdmin:

What is phpMyAdmin?

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.

Your WordPress website can either be based on WAMP or LAMP

  • LAMP stack (Linux, Apache, MySQL, and PHP).
  • WAMP stack (Windows,Apache, MySQL, and PHP)

phpMyAdmin is used for administration of the database which is MySQL. The option of using phpMyAdmin is ideal when you don’t have access to your email address for resetting the password.

To change your password via phpMyAdmin, login into your web host via the cPanel.

When the phpMyAdmin app launches, click on the database with the WordPress installation you want to change.

  • After selecting the database, you will see the list of tables in your wordpress installation.
  • Select the ‘{table-prefix}_users’ table in this list and click on browse.
  • After the table is selected, you would see the users table rows.
  • Click on the edit button next to the username you want to change the password.
  • The user information fields form shows up with all the details of the selected user.
  • Update the value in the user_pass field and replace it with your new password.
  • In the function column, select MD5 from the drop-down menu.
  • Click on Go to reset your password.
  • Your password would be encrypted with MD5 hash (The MD5 message-digest algorithm is a widely used hash function producing a 128-bit hash value).
  • MD5 was selected because of its backward compatibility recognition in wordpress.

The phpMyAdmin password reset is for wordpress is ideal for when you don’t have access to your email address.