sql query for change password

Question

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

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

Execute the following query to change passwords for users.

UPDATE res_users
set password = '1' //New password
WHERE login = '1' // login name

Dennis · 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.

Nirmal Singh Rautela · 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":

This question has been flagged

Enjoying the discussion? Don't just read, join in!