Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
Hi,
Execute the following query to change passwords for users.
UPDATE res_users
set password = '1' //New password
WHERE login = '1' // login name
I think this is not possible now as the password in database is clearly seen encrypted.
Is there anyone managed to rewrite the SQL to include a suitable encrypt function to the plain text password?
Thanks.
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":
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
