We have quite a number of blogger clients who are on WordPress. Sometimes, it is quite common for us to forget our admin password especially when we have several active blogs and email accounts at the same time.
What will you do if you have forgotten the password for your self-host WordPress blog? Normally, we would just click the “Lost your password?” to recover. However, in a localhost environment, configurations may vary from machine to machine. Most of the time “Lost your password?” will not work as email system is either not supported or not properly setup.
In this article, we are going to show you the alternative to reset your password by login to your web-based control panel.
The Problem
Whenever you have forgotten your password or username, or both, WordPress suggest you use the “Lost your password?” function to help recover but email system was not properly setup in your localhost? Here’s the alternative!
The Solution
Login to cPanel /DirectAdmin. The URL should be http://localhost/cpanel for cPanel or http://localhost:2222 for DirectAdmin (it might vary depending on configurations). Click on phpMyAdmin.
cPanel
DirectAdmin
Under phpMyAdmin. Look for the database name on the left sidebar. In our case, it is called “wordpress“.
Click “wordpress“ to see its tables. Look for *_users, in our case it is called wp_users. Click it and you will notice a page change on the right frame. user_login shows your username(s), whereas user_pass shows your actual password. However, the actual password you have entered previously is unreadable and unusable now.
To reset your password (or edit the data for the specific user), Click on the “Pen” icon.
Look for “user_pass” field. Select “MD5” for the Function dropdown, and change its value to a new password, in our case the new password is call “admin“. Click GO once you are done.
That’s it! You’ve just changed the password for username admin to “admin“.
This tip is contributed by Sandesh Sethi, founder of Vobliq.com – a blog about designing, blogging and money making.
Hand-picked related articles
ServerFreak is ISO 27001:2022 certified
Here are 5 great reasons to cheer Firstly, let us tell you about the cert. ISO 27001:2022 is the world’s…
How to Ensure 99.9% Uptime for Your Website
99.9% uptime is crucial to keep your website steady and accessible. Here are ways to achieve this: Choose VPS or…
Shared Hosting Or VPS Hosting For Your Business
Performance, cost, control, and scalability are some of the important differences that exist between shared hosting and VPS hosting. Both options have different advantages depending on your business needs, budget, and growth plans.SHARED HOSTING: THE BASICS With shared hosting, your website shares the same server as many other…
10 Ways To Get Income Using Website
Did you know that websites can actually generate some sort of income for you? The good news is, with a…