Support Questions

Find answers, ask questions, and share your expertise

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

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.

@raouia

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

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.