How To Recover WordPress Lost Password Through PHPMyAdmin {Updated}


A laptop screen displaying PHPMyAdmin within cPanel, focusing on the process of resetting a WordPress password.

If you’ve ever found yourself locked out of your WordPress site because you’ve forgotten your password, don’t worry—there’s an easy way to reset it using PHPMyAdmin. This method bypasses the need to access your WordPress dashboard and allows you to reset your password directly through your website’s database.

In this tutorial, I’ll walk you through the steps to reset your WordPress password by logging into PHPMyAdmin via cPanel. You’ll be editing your database password to something you can remember, so you can regain access to your site in no time.

This tutorial walks you through how to reset your WordPress sites password by logging into PHPMyAdmin from cPanel and editing the database password to your own.

Step 1: Access cPanel
First, log into your web hosting account and navigate to cPanel. Once there, look for the “Databases” section and click on “PHPMyAdmin.”

Step 2: Select Your WordPress Database
In PHPMyAdmin, you’ll see a list of databases on the left-hand side. Click on your WordPress database to expand its tables. Look for the table named “wp_users” and click on it.

Step 3: Edit the User Password
Find the row that corresponds to your username. Click on the “Edit” link next to it. You’ll see a field named “user_pass.” This is where your password is stored. Select “MD5” from the dropdown menu under the “Function” column and enter your new password in the “Value” column.

Step 4: Save Changes
Once you’ve entered your new password, scroll down and click the “Go” button to save your changes. Your WordPress password is now updated!

Step 5: Log In to WordPress
Go back to your WordPress login page and enter your username along with the new password you just set. You should now be able to access your dashboard.

Resetting your password through PHPMyAdmin is a straightforward process that can save you a lot of hassle. It’s a useful skill to have, especially if you’re managing multiple WordPress sites.

Looking to get started? Contact an expert today! If you encounter any issues or prefer to have a professional handle it, we’re here to help.

Categories

Tags