Steps to Reset WordPress Password from phpMyAdmin

Imagine a situation when you can’t login to your WordPress site because your WordPress site is hacked and password is changed. There may be times when you don’t even remember your password or you just lost it. We all fall into these situations once in a while. So it is always beneficial to keep the knowledge of how to reset or recover your password. This article shows steps to reset WordPress password from phpMyAdmin.

Steps to Reset WordPress Password from phpMyAdmin

There are generally six methods to Reset WordPress Admin password

  1. Using the Lost Password option via email
  2. From Admin Dashboard
  3. From phpMyAdmin
  4. From using FTP
  5. Using MySQL Command Prompt
  6. From using Password Reset Script

Normally we change the admin password from dashboard but without password, we cannot log into dashboard. If you have no access to email too, then resetting your password from phpMyAdmin is the best option. In this article we will focus in resetting WordPress password using phpMyAdmin.

Steps to Reset WordPress Password from phpMyAdmin

PhpMyAdmin is a free and open source tool that handles the administration of MySQL or database with the help of a web browser. Before you jump into steps of resetting password using phpMyAdmin make sure you have following information to perform this task

  • The name of your WordPress database.
  • Your cpanel username and password

Steps to reset password using phpMyAdmin

  1. Identify the name of your database
  2. Launching phpMyAdmin
  3. Getting inside the database and the specific user’s table.
  4. Edit the row containing admin username and password and reset new password.

Below are the detail explanations of each step.

1. Identify name of your database
You must be able to identify your database before you perform any action in it. If you know your database you can proceed further. If you don’t know the name of your database, you can find it in the wp-config.php file which is located in your root WordPress Directory.

Steps to Reset WordPress Password from phpMyAdmin

In my case name of the database is ‘mustbeweb’.

2. Launching phpMyAdmin:

If you’re on a shared hosting plan and have cPanel, Login to cPanel using cpanel username and password. Then find phpMyAdmin under Databases.

Steps to Reset WordPress Password from phpMyAdmin

If you’re using localhost in WAMP or XAMPP server, you can type “localhost/phpMyAdmin” or “127.0.0.1/phpmyadmin” in the address bar of the browser to get inside phpMyAdmin.

Steps to Reset WordPress Password from phpMyAdmin

3. Getting inside the database and the specific user table

Steps to Reset WordPress Password from phpMyAdmin

If you are seeing phpMyAdmin for the first time do not panic. On the left side you can see all the databases available. Select the database that you are using for your WordPress installation. Click the plus sign of the database you want to open.  That opens the list of all the tables inside that database. Find and select table called wp_users.

Also Read:   7 Powerful Ways to Protect Your WordPress Site From Hackers in 2017

Steps to Reset WordPress Password from phpMyAdmin

In wp_users, the wp_ is the default prefix of the table. For security reasons if you have changed the prefix to something else during WordPress installation then that changed prefix will be displayed.  In my case the default prefix wp_ is changed to custom prefix hgfdtesx_.

Steps to Reset WordPress Password from phpMyAdmin

When you select the users table, it will be loaded.

4. Editing the row containing admin username and password and reset new password.

Locate the username whose password you want to reset. Here user_login is the username and user_pass is the password. The password is MD5 encrypted. To reset new password, click on the edit button having pencil icon as shown in the image.

Steps to Reset WordPress Password from phpMyAdmin

This will open the edit page. In the edit page you can change any value and functions you have previously set. Find a row named ‘user_pass’.

Steps to Reset WordPress Password from phpMyAdmin

Change the function of the user_pass row into MD5 as shown here.

Steps to Reset WordPress Password from phpMyAdmin

Now in the value field delete the old password and write down your new password. After these changes make sure you save the changes by clicking the GO button at the button.

Steps to Reset WordPress Password from phpMyAdmin

Now you have successfully reset your WordPress login password using phpMyAdmin.

Steps to Reset WordPress Password from phpMyAdmin

In this way you can reset password using phpMyAdmin.

 

The following two tabs change content below.
Kantiman Bajracharya

Kantiman Bajracharya

Kantiman Bajracharya is a freelance web developer. He is a computer geek who has a Bachelor’s degree in Computer Engineering. He has earned lots of satisfied customers while working for numerous successful projects. He is also a WordPress theme creator and web article writer. On free time he likes reading philosophy books, traveling and playing chess.

Share This Post