Reset your WordPress Password using phpMyAdmin
So I can remember…
I recently was attempting to update my WordPress based website and was unable to login in to the Dashboard because I had changed the password but then restored a backup of the site which had the earlier password which I no longer had a record of.
For some reason the email password reset functionality also was not working, and would throw the following error:
The e-mail could not be sent.
Possible reason: your host may have disabled the mail() function.
This may be a PHP version related problem.
Nevertheless, after some searching I found out it was possible to reset your password using phpMyAdmin in cPanel.
- First Log In to cPanel via your host provider.
2. Under the Databases section, click on phpMyAdmin.
3. Click on the name of your WordPress database.
4. Next click on the wp_users table.
5. Click on Edit beside your WordPress admin user.
6. In the user_pass field, paste your password by pressing Ctrl — V.
7. From the drop-down, select MD5.
8. Finally click on Go.
You should now see a success message from phpMyAdmin saying the database record was updated.
If you enjoyed this article and would like to help support my writing, then please subscribe to become a Medium Member. I will get a portion of your subscription fee and you get access to every story on Medium. Alternatively, you can buy me a coffee!
