Skip to Main Content

How to restore a lost password on WordPress

Divi: the easiest WordPress theme to use

Divi: The best WordPress theme of all time!

With over 901.000 downloads, Divi is the most popular WordPress theme in the world. It is complete, easy to use and comes with more than 62 free templates. [Recommended]

Do you want to reset your WordPress password using phpMyAdmin?

If you are unable to reset your WordPress password, there is a way to reset it directly using phpMyAdmin.

In this tutorial, we will show you how to easily reset a WordPress password from phpMyAdmin.

But, if you've never installed WordPress discover How to Install a WordPress Blog in 7 Steps et How to search, install and activate a WordPress theme on your blog 

But back to why we are here.

How to reset a wordpress password

Why reset Password from phpMyAdmin

WordPress makes it easy to reset your password. You can simply go to the login screen and click on the "Forgot your password?».

Wordpress login page

Clicking on it will take you to the reset password page where you can enter your username or email address to reset the password. After that, WordPress sends a password reset link to the email address associated with that user account.

However, if you don't have access to the email address or if your WordPress website can't send an email, you won't be able to reset your password.

Discover another way to recover your passwords by consulting our article: Simplify your life with a WordPress password manager.

In such a situation, you must reset your WordPress password directly in the database. The easiest way to do this is to use phpMyAdmin.

That said, let's see how you can easily reset a WordPress password from phpMyAdmin.

How to restore a password from PHPMyAdmin

First, you need to log into the cPanel dashboard of your WordPress hosting account. Then you have to click on the icon " phpMyAdmin Under the section of the database.

Using a phpmyadmin md5 function

This will launch the phpMyAdmin app where you need to select your WordPress database.

Selection of a wordpress database

You will now see the list of tables in your WordPress database. Then you have to look for the table " {table-prefix} _users In this list and click on the link " Browse " next to it. {table-prefix} will replace the prefix of your database.

Show users

Remark: Table names in your WordPress database may have a different table prefix than the one we show in our screenshot.

Easily create your website with Elementor

Elementor allows you to easily create any website design with a professional look. Stop paying expensive for what you can do yourself. [Free]

See also our article on How to rename images on a WordPress blog

You will now see the rows for WordPress users. Go ahead and click the edit button next to the username whose password you want to change.

Modify a phpmyadmin user

PhpMyAdmin will present you with a form with all the fields, and user data.

You must delete the value in the " user_pass And replace it with your new password. Under the function column, select MD5 in the drop-down menu and click on the button perform ».

Using a phpmyadmin md5 function

Your password will be encrypted using the MD5 hash, then it will be stored in the database.

Congratulations ! You have successfully changed your WordPress password using phpMyAdmin.

And if you take a look at How to force users to change passwords on WordPress

Now some of you may be wondering why did we select the MD5 hash to encrypt the password?

In older versions, WordPress used the MD5 hash to encrypt passwords. Since WordPress 2.5, he started using stronger encryption technologies. However, WordPress still recognizes MD5 to provide backward compatibility.

Read also How to complexify the hash of WordPress passwords with bcrypt

As soon as you log in using a password string stored as an MD5 hash, WordPress recognizes it and modifies it using the latest encryption algorithms.

In what follows, I suggest some WordPress plugins to add password protection.

1. WooCommerce Password Protection Products, Categories or Shop

This WordPress plugin allows you to password protect your entire website, a section of your online store, specific categories, products or pages. You will be able to create a password, hide the desired content from the public, and share it with specific people.

Woocommerce password protected products categories or shop plugin

You can also choose to display password protected pages in search engine results by allowing them to crawl those pages.

Stop wasting time and money!

Discover the best tool to create your blog, your online store blog or any other website in just a few clicks!

Read How to bypass blockers of ads on WordPress

Its functionalities are among others: password protection for a section or your entire website, the ability to create multiple passwords by importing them to create different rules for accessing your website, customizing the password protection page background, and much more.

Download Demo | Web hosting

2. Google Authenticator 5-Step Login Protection

This WordPress plugin allows you to create a temporary and one-time password, generated by your phone. Thus, even if someone knows your password, or has memorized it or even stole it, they will not be able to connect to your account.

5sec google authenticator 2 step login protection

Its main features are: a two-step login process that adds extra protection to your website, no SMS charges to shell out, no ability to hack your account without your phone, ability to enable or disable two-way authentication Steps an easy-to-use graphical interface, professional and fast customer support, detailed documentation and more.

Download Demo | Web hosting

3. Super Forms 

This is an add-on to the plugin Super Forms, through which you can password protect your forms on your WordPress site. You will also be able to hide the form for non logged in users, as well as specific user roles.

Super forms password protect user lockout hide add on

It is an easy to use module that is compatible with most popular browsers. It is also fully responsive!

Download | Demo | Web hosting

4. White Label Login for WordPress

Have you ever wanted to change the look of the default WordPress login window to make your website stand out from the crowd? Then the WordPress White Label Login plugin is perfect for you.

White label login wordpress plugin for security

This plugin provides a large amount of functionality such as password protection or a countdown maintenance mode. Its great asset is security with a two-step authentication system, Google reCaptcha integration, access by IP address, etc ...

In addition, this plugin integrates connection to your website via a social network account.

Download | Demo | Web hosting

5. Product Password Protector 

This is a fairly simple WooCommerce plugin that can be used to activate password protection for your products (general or individual for each product). So, if the administrator allows password protection for some products, the user will be prompted to enter the product's password to purchase it.Product password protector wordpress plugin for security

Its features are: ease of use via the dashboard, activating or deactivating password protection for your products, compatibility with most browsers, no coding required.

Download | Demo | Web hosting

Recommended Resources

Find out about other recommended resources to help you build and manage your website.


Here is ! That's it for this tutorial. I hope you can better protect your blog. If you have some Comments or suggestions, do not hesitate to let us know in the reserved section.

However, you will also be able to consult our resources, if you need more elements to carry out your projects of creation of Internet sites, by consulting our guide on the WordPress blog creation or the one on Divi: the best WordPress theme of all time.

But meanwhile, share this article on your different social networks


This article features 0 comments

Leave a comment

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

This site uses Akismet to reduce unwanted. Learn more about how your comments data is used.

Back To Top