Odoo Help


Wrong login/password

Nidhal Ghabara
on 4/23/16, 10:26 AM 3,505 views

i'm  sure that the password and the login are  true  !!!! how can i change it???


Ankit H Gandhi(AHG)

--Ankit H Gandhi(AHG)--

| 6 5 6
Baroda, India
--Ankit H Gandhi(AHG)--

Learning Python..

Ankit H Gandhi(AHG)
On 4/24/16, 3:09 AM

Dear Nidhal,

You can change from backend database.

Step-1: Connect to that database from terminal or user interface

Step-2: Fire update query

Example (in terminal)

1. Please type this command in terminal sudo su postgres

2. Then they will ask system password, Please enter it.

3. Then you will to write psql your_database_name

4. Fire that query, update res_users set password = 'Your new password' where login = 'Your_login_name';

Hope this help for you.


Ankit H Gandhi.

This does only work for versions 7 and older. Meanwhile the password is encrypted. See the link I have posted.

Ermin Trevisan
on 4/24/16, 3:19 AM

Ankit ,your way is absolutely correct and it works for me in odoo8 and 9 ..I think Ermin have no knowledge about this query..@Ermin .If you have no idea about this kind of stuff dont answered ..Lot of experts checking and give perfect solutions for all the problems .Thnaks for Community...Ermin Please

on 4/27/16, 12:42 AM

First understand the question and then answer.thats better...

on 4/27/16, 12:43 AM

alternate solution for this issue---> is go to pgadmin->connect to pg->selectthe database->Go to Schemas->Public->Tables->Go to res_users table->Rightclick and Go to scripts->Update Script->Run this query(update res_users set password = 'Your new password' where login = 'Your_login_name';)

on 4/27/16, 12:48 AM

Dep, this way did not work for me in version 9.0. I had to do it the way as described in the link I have provided. I might have been wrong lately, but that does not mean I'm wrong anytime. I have provided a legit answer to the question which was even asked without providing any useful information.

Ermin Trevisan
on 4/27/16, 1:18 AM

Dear Ermin..as per Ankit solution it works you can check ..in locally thats why I commented...Just go to res_users table and modify .It works im sure...

on 4/27/16, 1:43 AM

I broke my local pgadmin at the moment (I'm using Postgres 9.5 on the server, which is not compatible with my local pgadmin on Ubuntu 15.10), so I can not check it with reasonable efforts, but will do it. However, if Ankit's answer works, everything is perfect. If it doesn't work, for what reason it might be, as it happened to me and obviously also to the people in the thread I have linked, the second solution should work. Any way, the problem is solved and that's the important outcome.

Ermin Trevisan
on 4/27/16, 1:58 AM

Ermin Trevisan

--Ermin Trevisan--
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--

Ermin Trevisan
On 4/24/16, 3:17 AM

Please be more specific. Do you try to login as admin user?

If the login for a non-admin user does not work, login as admin, go to "Settings/Users" and change the password of the corresponding user. If you forgot the correct admin password and are not able to login as admin, then this may help you:https://github.com/odoo/odoo/issues/9806

Nidhal Ghabara
On 4/26/16, 5:41 PM

thank you all i fix it 

Your Welcome @ Nidhal.

Ankit H Gandhi(AHG)
on 4/27/16, 2:15 AM

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

4 follower(s)


Asked: 4/23/16, 10:26 AM
Seen: 3505 times
Last updated: 2/6/18, 5:40 AM