Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution
Highlighted

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

New Contributor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

Master Collaborator

@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 solution in original post

1 REPLY 1
Highlighted

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

Master Collaborator

@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 solution in original post