Differences

This shows you the differences between two versions of the page.

--- docker:nginx_proxy_manager:forgotten_password [2025/07/21 10:45] – [Modify User Credentials] peter
+++ docker:nginx_proxy_manager:forgotten_password [2025/07/30 09:19] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Docker - Nginx Proxy Manager - Forgotten Password ======
-===== With Standard SQLite =====
-==== Access the Docker Container ====
-<code bash>
-docker exec -ti nginx-proxy-manager bash
-</code>
-----
-==== Install SQLite ====
-<code bash>
-apt update
-apt install sqlite3 -y
-</code>
-----
-==== Open the Database ====
-<code bash>
-sqlite3 /data/database.sqlite
-</code>
-----
-==== Modify User Credentials ====
-Update the **user** table to reset the password.
-  * Either set a new password or revert to the default.
-Find your user:
-<code sql>
-SELECT id, name, email FROM user;
-</code>
-returns:
-<code>
-|Admin|some@email.com
-|User|some@email.com
-</code>
-=== Update Password with "new_password" for user Admin[1] ===
-<code sql>
-UPDATE auth
-SET secret = '$2b$12$ExC8EX3htFBpXtbO4DXp.eAZ1CtJbGlDhRhpVV1hHcWjV7cprebZi'
-WHERE user_id = 1;
-</code>
-<WRAP info>
-**NOTE:**  To update for User[2], then use ID number 2 (**WHERE user_id = 2;**)
-</WRAP>
-==== To check if Hash was changed ====
-<code sql>
-SELECT id, user_id, secret FROM auth WHERE user_id = 1;
-</code>
-<WRAP info>
-**NOTE:**  Change ID number at end for the required user.
-</WRAP>
-----
-==== Restart the Container ====
-<code bash>
-docker restart <container-name or id>
-</code>
-----
-===== With MySQL =====
-<code bash>
-sudo docker exec -it [database container id or name] sh
-mysql
-connect npm
-UPDATE user SET is_deleted=1;
-sudo docker restart [nmp container id or name] (start second ssh connection to do that)
-UPDATE user SET is_deleted=0;
-Login with:
-Login: admin@example.com
-Password: changeme
-</code>