Skip to Content
This question has been flagged
5 Replies
3832 Zobrazenia
Avatar
maharajg

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 get zero rows updated.


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?
 


Avatar
Zrušiť
Avatar
HIREN DANGAR
Best 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;

 

Avatar
Zrušiť
Avatar
Ermin Trevisan
Best 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

Avatar
Zrušiť
Avatar
maharajg
Autor Best 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 

Avatar
Zrušiť
HIREN DANGAR

Try to update admin login as well password too. Like this update res_users set login='user',password='a' where id=1;

maharajg
Autor

tried update res_users set login='admin',password='a' where id=1; , got response Query returned successfully: one row affected, 32 msec execution time.

still unable to login, im sure im missing something very silly, cant figure out what.

HIREN DANGAR

Brother, This is the general query for reset the admin password through database.

Try reset both login and password of Admin.

update res_users set login='a' , password='a' where id=1;