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

is there any way to reset ranger admin UI password ?

Solved Go to solution
Highlighted

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

11 REPLIES 11
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

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?