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

Hash

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

python

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'

Database

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.

Login

Now I can login to my account with my password:

secret!password