Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

sql query for change password

By
Amol Gangajaliwale
on 7/2/13, 9:38 AM 1,481 views

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

0
Jack
On 7/2/13, 9:57 AM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 7/2/13, 9:38 AM
Seen: 1481 times
Last updated: 3/16/15, 8:10 AM