Oodo 12 CE on wondows 10 unable to reset admin password

Question

Hi Im new to oodo, ive installed oodo 12 community edition on windows 10. I setup my db and login username and password as admin / admin. After setup ive been using for a few days and for some reason i logged out and when i try to login to http://localhost:8069/web/login , Email - admin, password - admin is not working same is the case if i enter my email and try the same password.
im able to login to be postgresql. I tried using
*update res_users set password='test' where login='admin'**;* *​*i

HIREN DANGAR · Accepted Answer

Hello,
If you are forget your admin password than try to use below query to change password force fully.
*update res_users set password='a' where id=1**;*

Ermin Trevisan · Answer

According to my knowledge, you should create a password hash and reset the hash in the database if you want to be sure your password is encrypted.
You may want to check my post here:  https://www.odoo.com/forum/help-1/question/how-to-reset-the-odoo-database-admin-password-a-summary-for-different-odoo-versions-131992#answer-131994 [1]

[1] https://www.odoo.com/forum/help-1/question/how-to-reset-the-odoo-database-admin-password-a-summary-for-different-odoo-versions-131992#answer-131994

maharajg · Answer

Thanks tried this,
Query returned successfully: one row affected, 31 msec execution time.
While logging, getting Wrong Login/Password error.
When i try SELECT login, password FROM res_users WHERE id=1;
i get
"__system__";"a"
This is not resolved yet, dont know why it shows resolved

Этот вопрос был отмечен

I had the same issue few weeks back and i thought i have forgotten the password so i reinstalled the whole thing and dont want to go through the same again.

Any help to reset password?

Не оставайтесь в стороне – присоединяйтесь к обсуждению!