تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
3 الردود
10657 أدوات العرض

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

الصورة الرمزية
إهمال