Hi,

If you can't log in to your Odoo 18 Community instance, try the following steps:

1. Try Incognito/Private Window

Sometimes the browser cache causes login issues.

    Open a private/incognito browser window

    Go to your Odoo URL

    Manually enter your email and password or PIN

2. Check Email Settings (If Reset Email Not Working)

If you're not receiving the reset email:

    Go to Settings > Technical > Outgoing Mail Servers

    Make sure your SMTP server is set correctly

    Click “Test Connection” to confirm it works

    Also check Email Queue under Settings > Technical > Email > Emails – see if the email is stuck or failed

3. Reset Password Manually via PostgreSQL (If Still Locked Out)

If you have server access:

    Connect to the database using psql

    Run this SQL to reset the password:

   UPDATE res_users SET password = 'newpassword' WHERE login = 'user@example.com';

    Replace 'newpassword' with your own and use the correct email/login.

You can now log in with the new password.

Hope it helps.

I am still locked out, USER ignored, as well as Password, could not connect to server: could not translate host name "psql" to address : Unknown host

On sql shell This is what i get,

Server [localhost]: 127.0.0.1

Database [postgres]: [odoo]

Port [5432]: 5432

Username [openpg]: user_name

password for user user_name

psql: error: could not connect to server: FATAL: password authentication failed for user user_name