I was setting up a new WordPress site. The installation went fine and I was redirected to login for the first time. I typed in the password and it didn’t work. I tried again. I tried again. Nothing work. I tried the link to reset my password but it said email wasn’t configured. Since a new WordPress installation, I probably didn’t have something set correctly. So, I did a Google search to try to figure out my options. Fortunately, there is a method to reset your password.
This method that a little understanding of the database that runs WordPress so it might seem a little complicated but I had just installed WordPress so there wasn’t much risk. I could always delete everything and install WordPress again.
The first step is to login into phpMyAdmin to access the MySQL database. There should be a way to start this program in your web hosting account. Here are the remaining steps:
- Find the database table “users” though the name might start with a prefix.
- Find your username and click edit
- Find the column “user_pass” and enter a new password.
- The key is to set the function to MD5 so the password is then encrypted.
- Click Go to save the change.
Reference: