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.
There are generally six methods to Reset WordPress Admin password
- Using the Lost Password option via email
- From Admin Dashboard
- From phpMyAdmin
- From using FTP
- Using MySQL Command Prompt
- 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
- Identify the name of your database
- Launching phpMyAdmin
- Getting inside the database and the specific user’s table.
- 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.
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.
3. Getting inside the database and the specific user table
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.
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_.
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.
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’.
Change the function of the user_pass row into MD5 as shown here.
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.
Now you have successfully reset your WordPress login password using phpMyAdmin.
In this way you can reset password using phpMyAdmin.
Latest posts by Kantiman Bajracharya (see all)
- What are Different WordPress Theme Licensing Terms? - December 21, 2017
- 4 Tips to Optimize Your WordPress for Social Media Share - November 30, 2017
- What is WordPress? Is WordPress Free? Why is WordPress so popular? - November 22, 2017