Skip to Content
Dette spørgsmål er blevet anmeldt
3 Besvarelser
11312 Visninger
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
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar

Hi,


Execute the following query to change passwords for users.


UPDATE res_users

set password = '1' //New password

WHERE login = '1' // login name

Avatar
Kassér
Avatar
Dennis
Bedste svar

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
Kassér
Avatar
Nirmal Singh Rautela
Bedste svar

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
Kassér