Please let me know. Thank you. My email address is [email protected]
Hello! Your "project login name and password" most likely refers to the n8n interface login credentials (since you have two n8n services under your account). Here are the specific ways to reset them:
When n8n is deployed on Zeabur, it also spins up a PostgreSQL instance to store account data. You can reset the password by executing SQL commands via the PostgreSQL service in the Zeabur dashboard. Refer to this detailed tutorial by Raven:
👉 EP-17 What to do if you forgot your n8n password after deploying on Zeabur
Brief Steps:
Step 1 — Query your n8n account
Go to the Zeabur dashboard → your n8n project → PostgreSQL service → "Execute SQL" tab → Execute:
SELECT id, email FROM zeabur.public.user;
Note down the email address for which you want to change the password.
Step 2 — Generate a new bcrypt-encrypted password locally
import bcrypt
print(bcrypt.hashpw("YourNewPassword".encode(), bcrypt.gensalt()).decode())
The output will be a string similar to $2b$10$xxxxxxxxxxxxxxxxxxxxx. Copy it.
Step 3 — Update the password in PostgreSQL
Return to the "Execute SQL" tab of the PostgreSQL service:
UPDATE zeabur.public.user
SET password='The bcrypt string generated in Step 2'
WHERE email='Your account email';
After execution, go back to the n8n interface and log in with the new password.
After resetting your password, it is recommended to configure n8n SMTP so that you can reset your password via email if you forget it in the future, without needing to modify PostgreSQL again.
Using Gmail as an example:
n8n, and you will receive a 16-character password).N8N_SMTP_HOST=smtp.gmail.com
N8N_SMTP_PORT=465
N8N_SMTP_USER=Your Gmail address
N8N_SMTP_PASS=The 16-character app password generated just now
N8N_SMTP_SENDER=Your Gmail address (or custom display name)
N8N_SMTP_SSL=true
Once set up, you can use the official n8n email reset process in the future without touching SQL.
email column in the database directly, as other n8n tables use the user ID/email for associations.zeabur.public.user (e.g., if you have modified the settings yourself), please verify the actual schema location first.If you encounter any errors during the process (e.g., SQL errors, bcrypt generation failure, etc.), feel free to paste the error message, and we will continue to assist you. Thank you for your hard work!
This post has been inactive for a while. We will be closing it in 2 days if there is no new activity.
I still don't understand.
Done.
Great! 🎉 We will go ahead and close this ticket. If you have any further questions, feel free to open a new post. Thank you for your patience!
New replies are disabled for resolved issues.