is there any way to reset ranger admin UI password ?

[#1]

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

[#2 · 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.

[#3]

@kkulkarni what's the database flavor ?

[#4]

mysql-5.1.73

[#5]

I was just able to confirm that the update command listed is Postgresql database flavor.

[#6]

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

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

[#7]

Thank you so much @Neeraj Sabharwal

[#8 · 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.

[#9]

Thank you so much @sneethiraj 🙂

[#10]

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

[#11]

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