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.
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!
Login to cPanel /Direct Admin. The URL should be http://localhost/cpanel for cPanel or http://localhost:2222 for Direct Admin (it might vary depending on configurations). Click on phpMyAdmin.
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.