Chapter 2. Installation Prerequisites

A MySQL server of Oracle Server database instance running and available to be used by Ranger.

For the Ranger Admin host, either MySQL Client or Oracle Client is installed so Ranger can access the database.

The DBA Admin user (root in the case of MySQL or SYS for Oracle(is enabled in the database server from any host. To enable the DB Admin user, enter the following commands:

create user 'root'@'%' identified by 'rootpassword': --->only if this user does not
          exist grant all provileges on *.* to 'root'@'%' identified by 'rootpassword' with grant
          option; flush privileges;

set password for 'root'@'localhost'=password \('rootpassword');

Execute the following commands on the Ambari Server host:

replace

database-type

with

mysql

or

oracle

, and /jdbc/driver/path based on the location of the MySQL or Oracle JDBC driver;

ambari-server setup --jdbc-db={database-type} --jdbc-driver={/jdbc/driver/path}