{"id":7186,"date":"2023-05-05T21:48:37","date_gmt":"2023-05-05T16:18:37","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=7186"},"modified":"2023-05-05T21:50:39","modified_gmt":"2023-05-05T16:20:39","slug":"how-to-reset-an-odoo-user-password-in-the-database","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-an-odoo-user-password-in-the-database\/","title":{"rendered":"How to reset an Odoo user password in the database"},"content":{"rendered":"\n

Introduction<\/strong>

Odoo ERP is an online SaaS solution for supporting and integrating business activities such as production planning, manufacturing, logistics, finance, accounting, warehouse management, and human resources. The key benefits of Odoo are: Integrate systems and services. Automate the business process

Prerequisite<\/strong><\/p>\n\n\n\n

    \n
  1. A user with sudo privileges to SSH the server<\/li>\n\n\n\n
  2. Live Database name<\/li>\n\n\n\n
  3. A user name that we want to reset the password<\/li>\n<\/ol>\n\n\n\n

    Implementation<\/strong><\/p>\n\n\n\n

    Step 1: SSH the server <\/p>\n\n\n\n

    $ ssh user@IP<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Step 2: Switch to the Postgres user<\/p>\n\n\n\n

    $ sudo su – postgres<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    Step 3: Connect to the PostgreSQL (Odoo\u2019s database) shell to modify the database<\/p>\n\n\n\n

    $ psql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    Step 4: Check the database name which is associated with the odoo user 

    <\/p>\n\n\n\n

    $ \\l<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    Step 5:  Connect to the Odoo database <\/p>\n\n\n\n

    $ \\c test<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Note: change the test to the actual name of the Odoo database<\/em><\/p>\n\n\n\n

    Step 6: Check the user\u2019s email value (which is used as the login), execute the following command to get a list of all user logins<\/p>\n\n\n\n

    $ select login from res_users;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    Step 7: Change the password for the user <\/p>\n\n\n\n

    $ update res_users set password = ‘new_hashed_password’ where login = ‘your@email.com’;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Note: change your@email.com to the actual email value and change new_hashed_password with the required password <\/em><\/p>\n\n\n\n

    Step 8: Exit the database<\/em><\/p>\n\n\n\n

    $ \\q<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

    Introduction Odoo ERP is an online SaaS solution for supporting and integrating business activities such as production planning, manufacturing, logistics, […]<\/p>\n","protected":false},"author":495,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[974],"class_list":["post-7186","post","type-post","status-publish","format-standard","hentry","category-web-architecture","tag-odoo","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-1RU","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/495"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7186"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7186\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}