wordpress problems

How to reset WordPress admin password from phpMyAdmin database

Overview

Occasionally, situation may arise when you’re unable to remember your WordPress blog login password, and all of sudden you aren’t even able to reset it using registered e-mail address.

Another reason could be worse than this general situation. Your website is hacked and WordPress password is compromised.

This is why it becomes very essential for you to know how you can reset your WordPress password in these situations using phpMyAdmin functions.

Previously, we have helped many of our readers. This is the reason I am taking this time out to do this writeup.

 

Basic information

Without a database a WordPress blog cannot run, this database can be accessed through the phpMyAdmin section that is available within the cPanel.

Every database has username to control and access the content of it. Now, you are advised to follow the above steps in order to reset your password.

wordpress problems

 

Knowing your database

This is first and foremost thing you should know before you process to make necessary changes. Sometimes, you can run multiple installations within same database. Then it needs an adequate guide where to look to reset the password.

The best place is wp-config.php, which is located in the root installation of your WordPress blog. You can either use a FTP to open your root directory or access cPanel to have reached of it.

wordpress problems

 

Locating the database

Now, you need to login to your cPanel account using the credentials. Here, you will see phpMyAdmin function under the databases section. Now, click on the phpMyAdmin section to have access to your database.

Now, you have redirected to the main phpMyAdmin section to meet the entire databases you have with your hosting account.

Since you already know your exact database for your WordPress blog, click on it to access.

(Database name from file wp-config.php)

 

wordpress problems
Changing the password

All the tables of the database will appear on the main screen. You need to click on wp_users. If you have changed the prefix during installation you need to find specific prefix. E.g. wp234_users.

Now, you can click on edit option that will appear you filed look like below. Edit the user_pass field. You can see the existing password has random characters in password field. Due to security WordPress uses MD5 Hash rather plain text.

wordpress problems

 

Delete the existing password from user_pass and change it to your desired password. If you choose MD5 from the drop down menu it will encrypt your new changed password.

 

Now, click on the go button to save the changes you have made.

Here you have just changed your WordPress password from phpMyAdmin.

Share this article in social media and help the community

Facebooktwittergoogle_plusredditpinterestlinkedinmailFacebooktwittergoogle_plusredditpinterestlinkedinmail
The following two tabs change content below.
I am graduate & masters in computers and love all that comes digital. I am SEO enthusiast and SEO expert. I love to develop my skills and learn new trends and core knowledge. Being involved from last 7 years in this field, I love to do new challenges!!
Tags , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge