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
Tailoring Your Tech: Key Considerations for Customization & Compatibility on Shared Servers
While shared hosting provides a convenient starting point, several customization and compatibility factors should be considered: 1. Customization: Shared hosting…
Best Practices For Securing Websites On Shared Servers
Securing websites is more important than ever. Shared servers, popular for their affordability and ease of use, come with their…
Understanding Shared Hosting: What It Is & How It Works
Shared hosting is a web hosting service in which numerous websites reside on a single physical server, sharing its resources…
How A Bad Domain Name Can Affect Your Branding?
A bad domain name can negatively impact your branding in several ways. Here are five key points: An unprofessional or…