Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to reset Ambari Admin password?

Solved Go to solution
Highlighted

How to reset Ambari Admin password?

I have forgot Ambari Admin password after I had changed it from default, not able to login to Ambari UI now. Please suggest.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to reset Ambari Admin password?

An easier way, just run command bellow from linux terminal in ambari server host:

ambari-admin-password-reset

11 REPLIES 11

Re: How to reset Ambari Admin password?

New Contributor

You need to log into the database for example Postgres:

1. Log on to ambari server host shell

2. Run 'psql -U ambari-server ambari'

3. Enter password 'bigdata'

4. In psql:

update ambari.users set user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_name='admin'

5. Quit psql

6. Run 'ambari-server restart'

This will reset the admin account back to the password of 'admin'

Re: How to reset Ambari Admin password?

Most customers actually have user ambari for the database, so it would actually be:

2. Run 'psql -U ambari ambari'

Re: How to reset Ambari Admin password?

Password in #3 above is stored in /etc/ambari-server/conf/password.dat

Re: How to reset Ambari Admin password?

@pardeep.kumar@hortonworks.com

1) Postgres - As mentioned earlier

2) Mysql

Login as root user mysql -u root -p ( press enter, it will ask for password)

use mysql;

SET PASSWORD FOR 'admin'@'localhost'= PASSWORD('admin');

OR

UPDATE mysql.user SET Password=PASSWORD('admin') WHERE User='admin' AND Host='localhost';

localhost can be FQDN based on mysql setup

3) Oracle

Login as sys or system user

sqlplus sys as sysdba

alter user admin identified by 'admin';

Re: How to reset Ambari Admin password?

An easier way, just run command bellow from linux terminal in ambari server host:

ambari-admin-password-reset

Re: How to reset Ambari Admin password?

Guilhemme,

Could you please do a :

yum whatprovides 'ambari-admin-password-reset'

I just checked my 2.2.2 install and I do not see it:

[root@mon-orlan ~]# ambari (hit tab to complete)

ambari-python-wrap ambari-server ambari_server_main.py ambari-server.py

Re: How to reset Ambari Admin password?

Mentor

Orlando, you need to make sure agent is running and then you can execute the command, you won't see this script on the FS but once agent is up you may execute the command.

Re: How to reset Ambari Admin password?

For Users who are trying to Access this same thread for Ambari-2.7.0 and above, this commented method no longer works and you might need to refer to this link : https://community.hortonworks.com/articles/217295/ambari-270-how-to-reset-ambari-admin-password-from...

Re: How to reset Ambari Admin password?

Contributor

Artem, can you tell me how or where the ambari-admin-password-reset command is located. I'm guessing it's an alias, but it's not set in root on the ambari server. So where is it defined since you're saying it's not a file of some sort.