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

[#1]

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!

[#2 · Accepted solution]

@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.