question Re: Ranger Admin install fails with Access Denied error in Support Questions

Ranger Admin install fails with Access Denied error

ariesk1980 — Wed, 27 Jan 2016 16:57:25 GMT

I am seeing the following when it is trying to install Ranger Admin on the Ranger host server:

2016-01-27 08:48:59,962  [I] Database ranger already exists.
2016-01-27 08:48:59,962  [I] ---------- Granting permission to Ranger Admin db user ----------
2016-01-27 08:48:59,962  [I] ---------- Granting privileges TO user 'rangeradmin'@'%' on db 'ranger'----------
SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'hostname' to database 'ranger' ErrorCode: 1044
SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'hostname' to database 'ranger' ErrorCode: 1044
2016-01-27 08:49:00,520  [E] Granting privileges to 'rangeradmin' failed on 'ranger'

I have logged onto MySQL on the host machine and granted the following privileges and still the installation throws Access Denied error.

Re: Ranger Admin install fails with Access Denied error

jstraub — Wed, 27 Jan 2016 17:50:08 GMT

What privileges did you grant? I think there is something missing in your post

Re: Ranger Admin install fails with Access Denied error

rahulpathak109 — Wed, 27 Jan 2016 18:15:41 GMT

Try this:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'hostname' WITH GRANT OPTION;

Re: Ranger Admin install fails with Access Denied error

aervits — Wed, 27 Jan 2016 19:01:24 GMT

@Kay Aries you have MySQL issue not a ranger issue. Please see this Thread

Re: Ranger Admin install fails with Access Denied error

nsabharwal — Wed, 27 Jan 2016 19:21:11 GMT

@Kay Aries

Try this

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

then restart/reinstall rangeradmin process

Re: Ranger Admin install fails with Access Denied error

ariesk1980 — Wed, 27 Jan 2016 23:08:56 GMT

Ranger is in this state now:

Invalid event: HOST_SVCCOMP_OP_IN_PROGRESS at INSTALL_FAILED

I will delete the service through Rest API and will try it again.

Thanks for all the help.

Re: Ranger Admin install fails with Access Denied error

ariesk1980 — Thu, 28 Jan 2016 00:53:46 GMT

I did a re-install and Neeraj's solution worked for me. Thank you all, guys.

Re: Ranger Admin install fails with Access Denied error

ariesk1980 — Thu, 28 Jan 2016 09:51:58 GMT

Something like this:

GRANT ALL ON mydb.*TO'myuser'@'%';

Re: Ranger Admin install fails with Access Denied error

faizanm — Fri, 19 Feb 2016 22:10:24 GMT

Thanks Neeraj...your solution worked

Re: Ranger Admin install fails with Access Denied error

rchaman — Sat, 08 Jul 2017 06:46:02 GMT

It worked for me when used with "identified by 'password' " string in grant all privileges on *.* to 'root'@'oozie-test2' identified by 'password' with grant option;

Re: Ranger Admin install fails with Access Denied error

xavier1 — Tue, 20 Mar 2018 16:28:22 GMT

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

srinucse9 — Thu, 29 Mar 2018 18:54:26 GMT

Try this

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

Re: Ranger Admin install fails with Access Denied error

vinayk — Tue, 03 Jul 2018 17:01:06 GMT

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