How to reset Wordpress password without e-mail or phpMyAdmin
I don’t have SMTP services operational on my server at the moment so I had to do run a few Python commands and then login to the mysql client and update my user password field manually. Here’s how I did it.
- My system
- [Lenovo Legion T5] x86_64 Grub 2 Kernel 5.13 Manjaro Qonos 21.1 KDE 5.88 Plasma 5.23
Table of Contents
Python 3.11.3 (main, Jun 5 2023, 09:32:32) [GCC 13.1.1 20230429] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import hashlib >>> hashlib.md5("secret!password".encode("utf-8")).hexdigest() '5302217ea3e30b37da361dd3f441ba2d'
Then next thing I did was to login to my database client and update the user password using SQL:
sudo mysql -uroot -p
update wp_users set user_pass="5302217ea3e30b37da361dd3f441ba2d" where id=1;
Note that I already knew that my user Id was 1.
Now I can login to my account with my password: