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.

Is it necessary to create a database ranger?

Highlighted

Is it necessary to create a database ranger?

Hello,

I'm trying to configure database instance for Ranger. In my case, I've chosen MySQL. I'm following the steps mentioned in the following link:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_security/content/configuring_mysql_for_r....

This link does not mention to create a database named ranger. In others links it's mentioned to create it as indicated in the following link:

https://markobigdata.com/2016/08/08/adding-and-configuring-service-ranger-in-ambari/

So, should i create a database named ranger? Or, it's automatically created?

3 REPLIES 3
Highlighted

Re: Is it necessary to create a database ranger?

Hi @raouia

As you can see in the documentation, the following command gives global privileges to the ranger user (rangerdba) :

GRANT ALL PRIVILEGES ON *.* TO 'rangerdba'@'%';

With these privileges, this user will be able to create Ranger DB and all required tables/data.

I hope this helps.

Highlighted

Re: Is it necessary to create a database ranger?

@raouia

Does this answered your question? did you successfully install in Ranger installation?

Highlighted

Re: Is it necessary to create a database ranger?

You can create the database yourself or let ranger install scripts to create it for you - in that case you need to provide right privileges to the admin user as mentioned in the docs.

Name does not have to "ranger", you can configure it as per your env.

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