Forum

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:

Method 1: Change it within the n8n interface (if you still remember your current password)

1. Log in to your n8n interface.
2. Click your avatar in the bottom-left corner → Settings → My Profile.
3. You can modify your email and password there.

Method 2: Reset the password directly via PostgreSQL (if you have forgotten your password)

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.

Highly Recommended: Set up n8n password recovery (to avoid forgetting it next time)

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:

1. Log in to your Google Account Security page → Ensure "2-Step Verification" is enabled.
2. Go to the App Passwords page → Create an App Password (name it n8n, and you will receive a 16-character password).
3. Go to the Zeabur dashboard → n8n service → Variables tab → Add the following environment variables:

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

4. Save and restart the n8n service.
5. Log out of n8n → Click "Forgot Password" to test and confirm that you receive the password reset email.

Once set up, you can use the official n8n email reset process in the future without touching SQL.

Important Reminders

• Do not modify the email column in the database directly, as other n8n tables use the user ID/email for associations.
• It is recommended to back up PostgreSQL before changing the password (you can perform a manual backup from the Backup tab of the PostgreSQL service).
• Raven's original article also mentions that if your table is not in 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!

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!