is there any way to reset ranger admin UI password ?

[#1]

I have forgotten my ranger UI admin password. could you please help ?

[#2]

@kkulkarni what's the database flavor ?

[#3]

mysql-5.1.73

[#4]

@kkulkarni You can reset admin user password in mysql database. reset to admin

update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin' ;

[#5]

Thank you so much @Neeraj Sabharwal

[#6 · Accepted solution]

If you forget the admin password, you can reset it by executing db sql:

update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin';

This will reset the password to 'admin'. Then, they should change the password via UI.

[#7]

Thank you so much @sneethiraj :-)

[#8]

dont forget to change password in ambari as well, otherwise you will have issues restarting services:

https://community.hortonworks.com/questions/1929/changing-ranger-ui-password-causing-namenode-issue....

[#9]

Hi, is there anyway to change Ranger UI admin password through command line?

[#10]

Ambari Version 2.6.0.0

HDP version 2.6.3.0-235

Oracle Database 12c

Despite the restoration of the password in the database. I could not log into Ranger UI.

Changing the password in the Ranger configuration also did not give anything. I changed the password in the configuration: "Ranger Admin user's password for Ambari" and "admin_password".

What else can I do?