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.

Ranger installation failed

Solved Go to solution
Highlighted

Ranger installation failed

Expert Contributor

I was trying to configure Ranger, however installation failed with message 'java.sql.sqlexception: Access denied for user 'root'@'hiveserver' using password:YES.

ranger-error.png

Note: Am able to login to mysql 'mysql -u root -p' with default password 'hadoop'.

Kindly can some one assist me with the error am facing with Ranger installation.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Ranger installation failed

can you run these commands on your mysql database and retry:

GRANT ALL ON *.* TO 'root'@'hiveserver' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;

flush privileges;

2 REPLIES 2

Re: Ranger installation failed

can you run these commands on your mysql database and retry:

GRANT ALL ON *.* TO 'root'@'hiveserver' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;

flush privileges;

Re: Ranger installation failed

Expert Contributor

I have created new set of User with correct hostname and privileges and it worked, thankyou

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