There are times when we forget our username password combination and the forgot password link doesn’t send you a password link on the email specified due to hosting limitations or some other reason. That is when this method is helpful.
What we do here is, access the back-end of our WordPress installation and set up the password for our username
Here, username_db is your database name for the installation
If you’re having trouble updating passwords through phpMyAdmin, here is another method you can try: Emergency Password Reset Script
Once you have successfully logged in, access
Users > Your Profile section and scroll down to find New Password and then reset password again by clicking on
Generate Password. You can either use the pre-populated password or use your own password again and click on “Save Changes” so that WordPress can save the password. You’ll need to follow this extra step since WordPress secures your password with a salt, while the method we followed above to get into the dashboard doesn’t.