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

Selene — Thu, 23 Jul 2020 15:06:18 GMT

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!

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

GangWar — Thu, 23 Jul 2020 19:14:42 GMT

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

Find the Cloudera Manager server's database details from file /etc/cloudera-scm-server/db.properties.
Log in to CM database server.
Check if there is more than one user admin in the system.
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;
```

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;

question Re: How to reset Cloudera Manager Admin Password from the backend Database? in Support Questions

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

How to reset Cloudera Manager Admin Password from the Backend Database

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