4 hours ago
Hello n8n Support Team,
I installed n8n on a DigitalOcean server using Docker and created an administrator account with a password.
Unfortunately, I have forgotten the administrator password and I am currently unable to log in to my n8n instance.
I tried using the "Forgot Password" option, but it only tells me to contact the administrator to change the password. I am the owner and administrator of this n8n instance.
I also tried to reset the password through the server/terminal, but I was not successful. I believe I am running the commands inside the n8n Docker container rather than on the Docker host, so I cannot access the Docker CLI from there.
My setup is:
n8n version: 1.42.1
Installation: Docker
Hosting: DigitalOcean
Database: SQLite
EXECUTIONS_PROCESS: own
Operating system on my local computer: Windows 11
I have several important workflows and credentials stored in this n8n instance, so I do NOT want to lose or reset my existing data.
Could you please guide me through the safest way to reset or change the administrator password while preserving all my existing workflows, credentials, executions, and SQLite database?
I can provide screenshots, server information, or any other information you need to verify ownership of the instance.
Thank you for your assistance.
Best regards,
Omar
1 Replies
4 hours ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 4 hours ago
4 hours ago
This isn't DigitalOcean or n8n support, this is Railway support
If you have access to the n8n console, you should be able to reset the password via "n8n user-management:reset"
Otherwise if you have access to the database you can also just change the password field in the database :
UPDATE "user" SET "password" = 'PASS_HASH' WHERE "email" = 'admin@example.com';
(you can generate PASS_HASH via bcrypt, like: require('bcryptjs').hashSync('YourNewPassword', 10) )
(Note: this is the solutions I see from n8n community forums)