Can't log in to ambari. used almost all the passwords.

[#1 · Accepted solution]

@Gaurav Vats

You can reset the Ambari admin password by using the below steps.

1. Start your sandbox, ssh using a terminal or the web browser link

2. Run the following commands:

ambari-admin-password-reset

The following text will appear

Please set the password for admin:

Please retype the password for admin:

3. After setting and retyping your new password, type the command:

ambari-agent restart

4. Ambari Admin password should be reset

5. Open Ambari login page. Verify your new password allows you to login as admin user.

As always, if you find this post helpful, don't forget to "accept" answer.

[#2]

@Eyad Garelnabi

I think step 3 should be:

ambari-server restart

There's no need to restart the agent.

[#3]

Admin Server is restarted automatically after 'ambari-admin-password-reset' command is fired and password is provided to make password change effective so no need of 'ambari-server restart'. I feel step 3 is not mandatory but can be followed.

[#4]

@Gaurav VatsPlease run below query followed by Ambari server restart . Post that login using "admin" as password.

UPDATE ambari.users SET user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' WHERE user_name='admin';