Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

is there any way to reset ranger admin UI password ?

Solved Go to solution

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
Highlighted

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

10 REPLIES 10
Highlighted

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

@kkulkarni what's the database flavor ?

Highlighted

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

Super Guru

mysql-5.1.73

Highlighted

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' ;

Highlighted

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

Super Guru

Thank you so much @Neeraj Sabharwal

Highlighted

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

Highlighted

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

Super Guru

Thank you so much @sneethiraj :-)

Highlighted

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

Highlighted

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?

Highlighted

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

New Contributor

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?

Don't have an account?
Coming from Hortonworks? Activate your account here