Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

0040-how to reset the admin password for Cloudera Manager

Shulou Source: shulou.com Published: 2022-06-03 06:17:06 11月23日 Update

Warm Tip: to see the high-definition no-code picture, please open it with your mobile phone and click the picture to enlarge.

1. Problem description

If you forget the admin password for Cloudera Manager, you need to reset it. Then this article just can help you.

two。 Solution.

1. View the database configuration file for the Cloudera Manager service

Log in to the server where Cloudera Manager is located and view / etc/cloudera-scm-server/db.properties configuration

Get the user name and password of the CM database

You can see the following information in the database:

Database type: mysql

Database name: cm

User name: cm

Password: password

two。 Log in to CM's database server

[root@ip-172-31-6-14814] # mysql-ucm-p-D cmEnter password:. MySQL >

-u: specify the login database user name

-p: login database password

-D: specify the database name

3. Backup admin administrator user PASSWORD_HASH and PASSWORD_SALT information to text

Mysql > SELECT PASSWORD_HASH, PASSWORD_SALT FROM USERS WHERE USER_ID = 1 +-+-+ | PASSWORD_HASH | | PASSWORD_SALT | +-+ | 4a3beaf2c0d2799f7b7f8804bbd5f513fbba0aed6267080e4ec9ddb80457b5e9 | 4808527708840643472 | +-| -+-+ mysql >

4. Update admin administrator user PASSWORD_HASH and PASSWORD_SALT information

Mysql > update USERS set PASSWORD_HASH='2518db3278f704558ece63f469af87a7c12dbad8ff0971d3b677e291d61b44fc', PASSWORD_SALT=-5792243850706636683 WHERE USER_ID = 1bot query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0mysql >

5. Log in to CM with the "admin" user and the "admin" password

3. Summary

In the above way, the Cloudera Manager administrator password can be reset to the initial password "admin". Take the MySQL database as an example, other databases operate in the same way as above.

It is recommended to follow Hadoop practice, the first time, share more Hadoop practical information, welcome to forward and share.

Original article, welcome to reprint, reprint please indicate: reproduced from the official account of Wechat Hadoop

Tags: Data database password user login information user name administrator service management method server configuration consistent warm public method original article picture backup Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Linux Microsoft MariaDB Apple