Support Questions
Find answers, ask questions, and share your expertise

is there any way to reset ranger admin UI password ?

Super Guru

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: is there any way to reset ranger admin UI password ?

Explorer

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.

View solution in original post

12 REPLIES 12

Re: is there any way to reset ranger admin UI password ?

@kkulkarni what's the database flavor ?

Re: is there any way to reset ranger admin UI password ?

Super Guru

mysql-5.1.73

Re: is there any way to reset ranger admin UI password ?

Cloudera Employee

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

Re: is there any way to reset ranger admin UI password ?

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

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

Re: is there any way to reset ranger admin UI password ?

Super Guru

Thank you so much @Neeraj Sabharwal

Re: is there any way to reset ranger admin UI password ?

Explorer

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.

View solution in original post

Re: is there any way to reset ranger admin UI password ?

Super Guru

Thank you so much @sneethiraj 🙂

Re: is there any way to reset ranger admin UI password ?

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

Re: is there any way to reset ranger admin UI password ?

Explorer

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