question Re: How to reset Ambari Admin password? in Archives of Support Questions (Read Only)

How to reset Ambari Admin password?

pardeep_kumar — Tue, 29 Sep 2015 17:41:21 GMT

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

Re: How to reset Ambari Admin password?

dgoodhand — Tue, 29 Sep 2015 17:47:25 GMT

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?

nsabharwal — Tue, 06 Oct 2015 20:06:59 GMT

@pardeep.kumar@hortonworks.com

1) Postgres - As mentioned earlier

2) Mysql

use mysql;

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

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?

orlandoteixeira — Sat, 27 Feb 2016 00:33:40 GMT

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?

wgonzalez — Sat, 25 Jun 2016 07:42:47 GMT

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

Re: How to reset Ambari Admin password?

gbraccialli3 — Tue, 05 Jul 2016 20:19:00 GMT

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?

orlandoteixeira — Tue, 05 Jul 2016 20:31:18 GMT

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?

aervits — Sun, 10 Jul 2016 19:38:33 GMT

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?

jeff_watson — Tue, 08 Aug 2017 05:45:30 GMT

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.

Re: How to reset Ambari Admin password?

masahiro_hirama — Tue, 29 Aug 2017 21:24:41 GMT

Just to contribute with alternative options for such case: my HDP sandbox had been used since beginning of HDP tutorial, i figure some configs were spoiled at the point that needed agentes and services went down. To stop running out of time, I just downloaded/imported a new Virtualbox HDP sandbox - since that, i could get back on track - i.e. Interact with sandbox following tutorial instructions ("HDP > develop with hadoop > Hello World", "6. Interactive SQL on Hadoop with Hive LLAP ", "Enable Ambari Admin Login" , https://br.hortonworks.com/tutorial/learning-the-ropes-of-the-hortonworks-sandbox/#section3 , '2.2 Setup Ambari admin Password Manually' ) - it has gone fine.

Re: How to reset Ambari Admin password?

akhilsnaik — Mon, 03 Sep 2018 20:29:07 GMT

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

Re: How to reset Ambari Admin password?

DennisJaheruddi — Sat, 01 Dec 2018 07:22:17 GMT

The best answer is not up to date. From Ambari-2.7.0 this works (as commented by @Akhil S Naik😞 https://community.hortonworks.com/articles/217295/ambari-270-how-to-reset-ambari-admin-password-from.html

Re: How to reset Ambari Admin password?

Peter118 — Thu, 11 Jun 2020 20:27:50 GMT

Our installation had the password hash in another table.

update ambari.user_authentication set authentication_key='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_id='1'

Note: user_id=1 was the admin in my case.