Would you like to reset a lost 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 et How to search, install and activate a WordPress theme on your blog
But back to why we are here.
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 password?».
Clicking on it will take you to the password reset 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 reset a password from PHPMyAdmin
First, you need to login to the cPanel dashboard of your account.accommodation WordPress. Next, you need to click on the “ phpMyAdmin Under the section of the database.
This will launch the phpMyAdmin app where you need to select your WordPress database.
You will now see the list of tables in your WordPress database. Then you need to search 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.
Please note:: Table names in your WordPress database may have a different table prefix than the one we show in our screenshot.
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.
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 column Function, select MD5 from the drop-down menu and click on the button Execute ».
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
Ce 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 to specific people.
You can also choose to display password protected pages in search engine results by allowing them to crawl those pages.
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
Ce WordPress Plugin allows you to create a temporary, one-time password generated by your phone. Thus, even if someone knows your password, or has memorized it or even stolen it, they will not be able to connect to your account.
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.
It is an easy to use module that is compatible with most popular browsers. It is also fully responsive!
Download | Demo | Web hosting
Recommended Resources
Find out about other recommended resources to help you build and manage your website.
- How to Create a Website Specific WordPress Plugin
- How to fix the error of access to a page of the WordPress dashboard
- What should you know before doing affiliate marketing WordPress
- 5 WordPress plugins to create a blog portfolio
- How to rename images on a WordPress blog
Conclusion
So ! That's it for this tutorial. We 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.
...