The purpose of this is to reset the password of an uptime kuma installation. The motivation behind this is that I forget my password for the uptime kuma very frequently. So I need to reset them every 4-6 months (⓿_⓿).
So I'm just documenting the flow here for anyone that needs it.
if you are running the uptime kuma in a docker, then at first go inside the container
docker exec -it uptime-kuma bash
Install sqlite in the container
apt install sqlite
  
  
  Locate the kuma.db file and open it in sqlite, for my case it is in the /app/data
sqlite3 /app/data/kuma.db
You can list all the users using this query and note the id
SELECT * FROM user;
Run this command to update the password
UPDATE user SET password="$2y$10$IWoZl5q9Tvvp1wxROvi4hOul7XP.rfyrvm4xbm7ufVANke1nfvLIu" WHERE id=1;
If you want to set a specific password then just go to this website and generate the bcrypt password. Then put it inside the sql password="<encrypted_password>".
  
  
  Now you can just log in to your user account using the password password, don't forget to change the password after you log in.
Thanks for reading, let me know if you face any issue (it can be any webdev/devops related issue) and a star on the repo will be much appreciated :)
 
 
              
 
    
Top comments (1)
That was really helpful, thank you Minhaz.