Hello, i forget my admin odoo14 CE password (installed on a remote ubuntu 20.04) , and can't recover it from UI, How can i set it from SSH Please ?
I want to connect directly via ssh to the database and reset it ? does it work ? how to do it exactly ? thanks in advance.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
3
Replies
3960
Views
video reference here
thank you very much !
Hello BENKOULAL RAMZI WASSIM,
I hope you find this message well.
Please find below steps to change the Odoo 14 user password in Ubuntu 20.04 from SSH:
1. Open Terminal in your system (Ctrl+Shift+T).
2. SSH into the desired server: ssh your_username@your_system_ip_address (eg, odoo@192.159.2.524).
3. Enter your system password (in this case, the password for the "odoo" system user).
4. Access PostgreSQL: sudo su - postgres.
5. Enter the PostgreSQL password.
6. Enter the desired database: psql db_name.
7. Change the password: UPDATE res_users SET password='your_new_password' WHERE login='admin'; (ensure the password is enclosed in single quotes, eg, UPDATE res_users SET password='odoo' WHERE login='admin'.
8. Commit changes: \q.
9. Restart service: sudo service postgresql restart. (make sure to restart the service).
I hope this information proves helpful to you.
Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Dec 20
|
5896 | ||
|
|
0
Feb 21
|
3818 | ||
|
3
Sep 25
|
3576 | ||
|
0
Aug 25
|
1039 | ||
|
1
Aug 25
|
3392 |
