Learn Wordpress

Initially built as Blogging Application, Wordpress quickly evolved into the most used CMS today!

• Last Updated: 07/18/2020
• ( 2 minutes reading )

How to change your WordPress Admin Password through phpMyAdmin

Introduction

The typical procedure of changing or resetting a WordPress admin password is effortless and straightforward. However, what happens if you can no longer log into your dashboard, you have lost access to the administrative email address of your account, or the password reset email delivery fails?

Do not get frustrated. There is a solution to regain access to your WordPress Admin Dashboard, even in such a despairing scenario. All you have to do is change the password directly from the database through the phpMyAdmin tool integrated into cPanel. At first, that might sound like a task requiring quite advance skills, but it is actually relatively simple, and we are going to step-by-step guide you on it!

Let's not waste more time and jump straight into it!

 

Getting Started

First, you have to log into your cPanel account. If you are not sure how to do that, please find detailed instructions in our tutorial on How to access the cPanel service.

Once logged, please navigate to the "Databases" features group, where you will locate the "phpMyAdmin" tool.

 

Access phpMyAdmin from cPanel

 

Upon accessing phpMyAdmin, a list of all available databases in your hosting account will be presented in the left column. Please navigate through it and locate the database associated with your WordPress website. When you find it, click on the corresponding plus sign (+) to list the database tables.

The table you are looking for is "wppt_users" - please click on it.

 

Access WordPress Database wppt_users table

 

Once the table selected, the entries will be presented within the middle of the screen.

 

Changing the Admin Password

Now that you have accessed the intended table, please locate the user account you want to change the password for and click on the "Edit" link in front of it.

 

Edit WordPress Database Admin User Entry

 

Next, you will be presented with the user information. In the "user_pass" line, please make sure to select "MD5" from the dropdown in the "Function" column and enter your new password within the field in the "Value" column.

When ready, make sure to click on the "Go" button positioned in the bottom right corner of the table.

 

Change WordPress Admin Password from phpMyAdmin

 

With this done, your password is changed, and you may use the new one to log into your WordPress Admin Dashboard.

 

Well done! In this tutorial, you have learned how to gain access to your WordPress Admin Dashboard by changing your password directly through the database. We hope this tutorial saved you an unnecessary headache. In case you do not feel confident enough to perform the change on your own, please make sure to submit a ticket request to our Technical Support Team from your HostArmada Client Area.

 

 

...
Sebahat
Content Marketing Specialist

Sebahat is a young and bright woman who has become an invaluable part of our team. She started as a Customer Care Representative, mastering that role and, along the way, growing into a tech-savvy individual who is well acquainted with every support layer of the company. Driven by her aim to improve our customers’ experience constantly, she is committed to enhancing the extraordinary support we deliver.