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
Ways to Improve Your Site’s Ranking (SEO)
Use these actionable tips to take your SEO to the next level and send your website ranking up to the top of the search engine rankings. Gain more visibility, drive organic traffic, and set your…
Benefits Of SEO
Whether it's a new business or growing one, just think of your business popping up on the first page when…
Who Should Use Shared Hosting
If you fall into any of the categories below, shared server hosting might be suitable for you: 1. Small Businesses…
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…