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.
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.