How to reset Wordpress password without e-mail or phpMyAdmin

Image credit:

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


First I used the Python REPL to get the encrypted version of my chosen password:

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()


Then next thing I did was to login to my database client and update the user password using SQL:

sudo mysql -uroot -p
use mybigdatabase;
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:

Steven Almeroth
Steven Almeroth
Code Of Honor

Steven was born at a very early age in the same year that his father, Peter, began working for Hewlett-Packard in Chicago and within a dozen years together completed Adventure.