Odoo Help


How to recover the Admin password

on 8/26/16, 8:43 AM 2,169 views

Hi Experts,

I've install Odoo 8 on my laptop (Ubuntu 16.4) few days ago. And I forget the administrator password to access to the DB. I tried to recover it from "/etc/odoo/openerp-server.conf", but it's not working??

Bellow, my configuration file:


; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = False

addons_path = /usr/lib/python2.7/dist-packages/openerp/addons

Please do have any solution to this issue?

Thank you in advance.


Thank you for your quick answer, but unfortunately it still not working!! 

on 8/26/16, 10:09 AM
Ray Carnes
On 8/26/16, 2:00 PM

If you or someone else changes the admin password via the User Interface (by clicking SET MASTER PASSWORD), then it is stored in a file called .openerp_serverrc which is stored in the home folder of the user account used to run the Odoo service.

On 8/26/16, 11:12 AM

Odoo system has three different passwords:

1) Paremeter admin_passwd in openerp-server.conf

This password allows you to manage databases, when you browse address

localhost: 8069 / web / database / manager

In this case, to set new: Remove the semicolon at the line start, set your password and restart odoo.

2) Paremeter db_password in openerp-server.conf

This is the password of role with name odoo in postgresql (parameter db_user = odoo in openerp-server.conf)

In this case, to set new, see https://www.postgresql.org/docs/9.0/static/sql-alterrole.html

In your case this password probably is empty (db_password = False)

3) Main Odoo user password, user with login = admin (or with your email).

In this case, to set new, replace the password and hash in the database with the new one by running this SQL query:

UPDATE res_users SET password = "NEW_PASSWORD",password_crypt = NULL WHERE id=1;

To retrieve login:

SELECT login, password FROM res_users WHERE id=1;

IMPORTANT!!! After update res_users (after setting NEW_PASSWORD) you login to Odoo and set new password again (If you need crypted password in database)

Ermin Trevisan
On 8/26/16, 9:37 AM

Your admin password is commented out. Remove the semicolon at the line start and restart odoo.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/26/16, 8:43 AM
Seen: 2169 times
Last updated: 8/31/16, 3:23 AM