Skip to main content
Selene
Selene
Bronze ⭐️⭐️⭐️
July 23, 2020
Solved

How to reset Cloudera Manager Admin Password from the backend Database?

Hello

I would like to know

How to reset Cloudera Manager Admin Password from the Backend Database

Database version: Mysql 5.7.29

CM version: 6.3.x

Authentication method  for the "Authentication Backend Order": External then Cloudera Manager

 

Thanks in advanced!

GangWar
GangWarAnswer
Platinum ⭐️⭐️
July 23, 2020

@Selene Please take a backup of database and then you can follow below steps: 

 

  1. Find the Cloudera Manager server's database details from file /etc/cloudera-scm-server/db.properties.
  2. Log in to CM database server.
  3. Check if there is more than one user admin in the system.
  4. Take a back up of password_hash and password_salt of the Admin user and paste them into a text editor:

    SELECT password_hash, password_salt FROM users WHERE user_id = 1;

  5. Update password_hash and password_salt for user "admin" using the following command:

    update USERS set password_hash='2518db3278f704558ece63f469af87a7c12dbad8ff0971d3b677e291d61b44fc', password_salt=-5792243850706636683 WHERE user_id = 1; 

  6. Log in to the CM interface using admin user and admin password.

 

Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
View in thread

1 reply

GangWar
Platinum ⭐️⭐️
GangWarAnswer
Platinum ⭐️⭐️
July 23, 2020

@Selene Please take a backup of database and then you can follow below steps: 

 

  1. Find the Cloudera Manager server's database details from file /etc/cloudera-scm-server/db.properties.
  2. Log in to CM database server.
  3. Check if there is more than one user admin in the system.
  4. Take a back up of password_hash and password_salt of the Admin user and paste them into a text editor:

    SELECT password_hash, password_salt FROM users WHERE user_id = 1;

  5. Update password_hash and password_salt for user "admin" using the following command:

    update USERS set password_hash='2518db3278f704558ece63f469af87a7c12dbad8ff0971d3b677e291d61b44fc', password_salt=-5792243850706636683 WHERE user_id = 1; 

  6. Log in to the CM interface using admin user and admin password.

 

Translate
Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
    Terms & ConditionsAccessibility statement