Created 11-20-2015 12:30 PM
I have forgotten my ranger UI admin password. could you please help ?
Created 11-20-2015 04:32 PM
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.
Created 11-20-2015 12:34 PM
@kkulkarni what's the database flavor ?
Created 11-20-2015 02:01 PM
mysql-5.1.73
Created 11-20-2015 04:19 PM
@kkulkarni You can reset admin user password in mysql database. reset to admin
update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin' ;
Created 11-21-2015 01:55 PM
Thank you so much @Neeraj Sabharwal
Created 11-20-2015 04:32 PM
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.
Created 11-21-2015 01:55 PM
Thank you so much @sneethiraj :-)
Created 12-01-2015 12:32 PM
dont forget to change password in ambari as well, otherwise you will have issues restarting services:
Created 05-21-2017 10:57 AM
Hi, is there anyway to change Ranger UI admin password through command line?
Created 12-05-2017 11:17 PM
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?