I have forgot Ambari Admin password after I had changed it from default, not able to login to Ambari UI now. Please suggest.
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'
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.
1) Postgres - As mentioned earlier
Login as root user mysql -u root -p ( press enter, it will ask for password)
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
Login as sys or system user
sqlplus sys as sysdba
alter user admin identified by 'admin';
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
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.
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...