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