Odoo Help


sql query for change password

Amol Gangajaliwale
on 7/2/13, 9:38 AM 2,705 views

I have created database in open ERP and set my admin password , it was working fine but suddenly it refuses to accept the password . I tried to change it through SQL query but password has not changed .

select login, password from res_users

2 UPDATE res_users SET password = '<ankit>' WHERE login = '<ankit>';

UPDATE res_users SET active = TRUE WHERE login = '<login>';

I have used these three commands

On 7/2/13, 9:57 AM

It will work but be conform you are executing Sql query in correct Database because i used it Various times...

update res_users set password="String" where login="User login name":

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

0 follower(s)


Asked: 7/2/13, 9:38 AM
Seen: 2705 times
Last updated: 3/16/15, 8:10 AM