Ranger installation failed

[#1]

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.

[#2 · Accepted solution]

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;

[#3]

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