1. Home
  2. Web Development
  3. Change Password of WordPress User using PhpMyAdmin

Change Password of WordPress User using PhpMyAdmin

Share

How to change the password of a WordPress user directly from phpMyAdmin? In this article, you will learn how to reset the password of a WordPress user by accessing its database. In particular, we will use phpMyAdmin, a very useful tool to access the WordPress database which is usually included by any WordPress site provider.

Prerequisites

PhpMyAdmin. Of course, we need to have phpMyAdmin, which is usually included in our WordPress hosting plan. Depending on which is our provider, the way to access phpMyAdmin may be different. For example, if you have cPanel, you will find a phpMyAdmin button in the “databases” section.

Database credentials. We need the credentials to access the database using phpMyAdmin. Indeed, think of phpMyAdmin as a graphical interface that we use to interact with our WordPress database. If you don’t remember your database credentials and you can access the file system of your WordPress instance, you simply need to open the wp-config.php file:

WordPress database credentials in wp-config.php file

DB_NAME, DB_USER, DB_PASSWORD contains, respectively, the database name, user, and password.

Change Password of WordPress User using phpMyAdmin

To change the password of a WordPress user using phpMyAdmin we need to:

  1. Log in to phpMyAdmin using the credentials we found in the wp-config.php filephpMyAdmin login
  2. in the upper left corner, select the database name corresponding to the name of your WordPress database select database phpmyadmin
  3. once you selected the database, in the input below the database name search for “user”, then click on the wp_users table wordpress users table
  4. on the right side of the page, click the “edit” button in the corresponding row of the user which you want to reset the password edit wordpress user password from phpmyadmin
  5. finally, insert the new password in the “user_pass” field and select “MD5” in the function columnreset password WordPress user
  6. Click on the “Go” button

That’s it! You successfully changed the password of a WordPress user using phpMyAdmin.

If you like our post, please share it:

Polynique © 2020 - 2021, made with ❤️ by a developer, for developers.

Latest update:

All trademarks, service marks and company names are the property of their respective owners.

AboutPrivacy PolicyCookie Policy