Recover Admin Password

Lost access to your Odoo admin account? This guide shows you how to reset the administrator password using OEC.sh.

Method 1: Using OEC.sh Terminal (Recommended)

The easiest way to reset your admin password is through the built-in terminal.

odoo shell -d YOUR_DATABASE_NAME << 'EOF'
env['res.users'].browse(2).write({'password': 'NewPassword123!'})
env.cr.commit()
print("Password reset successfully!")
EOF

Method 2: Using SQL (Direct Database Access)

If the Odoo shell method doesn't work, you can reset the password directly in PostgreSQL.

psql -U odoo -d YOUR_DATABASE_NAME

UPDATE res_users
SET password = 'temp_password_123'
WHERE id = 2;

\q

Method 3: Using Odoo Configuration

For Odoo 12.0 and later, you can set an admin password via configuration.

nano /etc/odoo/odoo.conf

admin_passwd = your_master_password

supervisorctl restart odoo

Finding Your Database Name

If you don't know your database name:

From OEC.sh Dashboard

1. Go to Environments
2. Click on your environment
3. The database name is shown in the Overview tab

From Terminal

psql -U odoo -c "SELECT datname FROM pg_database WHERE datistemplate = false;"

Common Issues

"User not found" Error

The admin user ID might not be 2. Find the correct ID:

SELECT id, login, active FROM res_users ORDER BY id;

"Permission denied" Error

Ensure you're connected as the correct database user:

psql -U odoo -d YOUR_DATABASE_NAME

Password Not Working After Reset

1. Clear your browser cache and cookies
2. Try an incognito/private window
3. Check if 2FA is enabled on the account

Prevention: Best Practices

1. Use a Password Manager - Store credentials securely
2. Set Up Multiple Admins - Create backup admin accounts
3. Document Credentials - Keep secure records of admin access
4. Enable Password Recovery Email - Configure SMTP so Odoo can send password reset emails

Setting Up Password Recovery Email

To enable the "Forgot Password" feature in Odoo:

1. Go to Settings → General Settings
2. Configure Outgoing Mail Servers (SMTP)
3. Ensure admin user has a valid email address
4. Users can now use "Reset Password" on login page

Need Help?

If you're still unable to access your account:

1. Check Logs - Go to Environment → Logs for error details
2. Contact Support - Email support@oec.sh with your environment ID