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 Admin install fails with Access Denied error

Solved Go to solution
Highlighted

Re: Ranger Admin install fails with Access Denied error

New Contributor

I am having this error as well,

where should I gran this permissions on the local terminal or inside the hdp?

and what is the command?

thanks for your help.

Re: Ranger Admin install fails with Access Denied error

New Contributor

Try this

grant all privileges on *.* to 'root'@'host' identified by 'password' with grant option;

Highlighted

Re: Ranger Admin install fails with Access Denied error

Expert Contributor

Hi,

We was facing same issue.We tried some resolution

First we tried:

grant all privileges on *.* to 'root'@'hadoop04' identified by 'password';

again we was facing same issue

SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'hadoop04' to database 'ranger' ErrorCode: 1044
2018-07-03 15:13:50,524  [E] Granting privileges to 'rangeradmin' failed on 'ranger'

we had tried with IP address

grant all privileges on *.* to 'root'@'ip_address_of_rangerhost' identified by 'password';

Which works for me.

Regards

Vinay K

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