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
Scalable VPS Hosting for Growing Businesses
Scalable VPS hosting lets you easily adjust resources like CPU, RAM, and storage to match your business needs. Unlike fixed…
Who Can Benefit From Cloud Hosting?
Uncover The Ideal Users Cloud hosting is ideal for various users and businesses because of its flexibility, scalability, and cost-effectiveness.…
Tips For Optimizing Your Cloud Hosting Environment
Optimizing your cloud hosting environment can improve performance, reduce costs, and enhance security. Here are some tips to help you…
Cost Savings with Cloud Hosting: A Financial Perspective
Cloud hosting offers several financial advantages compared to traditional hosting solutions. Here’s how it can help you save money: 1.…