How to reset Wordpress password without e-mail or phpMyAdmin

Wordpress Password

I forgot my Wordpress password and I don't have SMTP services operational on my server at the moment so I had update my user password field manually. Here's how I did it.

My system {{< fontawesome linux >}} : {{< fontawesome desktop-solid >}} [Lenovo Legion T5] x86_64 Grub 2 Kernel 5.13 Manjaro Qonos 21.1 KDE 5.88 Plasma 5.23

Contents

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