Skip ke Konten
Pertanyaan ini telah diberikan tanda
3 Replies
11307 Tampilan
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
Buang
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Jawaban Terbai

Hi,


Execute the following query to change passwords for users.


UPDATE res_users

set password = '1' //New password

WHERE login = '1' // login name

Avatar
Buang
Avatar
Dennis
Jawaban Terbai

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
Buang
Avatar
Nirmal Singh Rautela
Jawaban Terbai

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
Buang