Skip to Content
This question has been flagged
3 Replies
10344 Views
Avatar
Amol Gangajaliwale

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

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


Execute the following query to change passwords for users.


UPDATE res_users

set password = '1' //New password

WHERE login = '1' // login name

Avatar
Discard
Avatar
Dennis
Best Answer

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.

Avatar
Discard
Avatar
Nirmal Singh Rautela
Best Answer

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":

Avatar
Discard