question Re: Ranger installation failed in Archives of Support Questions (Read Only)

Ranger installation failed

sreeviswa_athic — Tue, 28 Mar 2017 23:05:45 GMT

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.

Re: Ranger installation failed

dsharma — Wed, 29 Mar 2017 00:26:14 GMT

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

sreeviswa_athic — Wed, 29 Mar 2017 01:19:10 GMT

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