@Bryan A I can help out on this. I just completed an HDP 3.0 cluster installation. Centos 7 comes with MariaDB, the setup steps are exactly the same, only different MariaDB is open source in fact its a spinoff of MySQL. Assumption: Database = MySQL MariaDB root user password=welcome1 MariaDB host =MySQL_host Ranger user password= ranger First, ensure you MariaDB/MySQL is up and running. # yum install -y mysql-connector-java Setup Ambari The below step can be re-run many times so no worries ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar Check status and enable autostart perform these steps as the root user # systemctl status mysql
# systemctl enable mysql.service
# systemctl start mysql.service Run the status check after the above sequence to validate that MariaDB is up and running Harden MySQL It's good practice to secure you MariaDB installation sudo mysql_secure_installation Ref: Secure MariaDB mysql -u root -pwelcome1
CREATE USER 'ranger'@'localhost' IDENTIFIED BY 'ranger';
GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'localhost';
CREATE USER 'ranger'@'%' IDENTIFIED BY 'ranger';
GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'%';
CREATE USER 'ranger'@'<MySQL/MariaDB_host>' IDENTIFIED BY 'ranger';
GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'<MySQL/MariaDB_host>';
FLUSH PRIVILEGES;
quit; Connect as user ranger mysql -u ranger -pranger
CREATE DATABASE ranger;
use ranger;
show databases;
quit; Now in the Ambari UI when configuring the ranger components see attached screenshot replace my hostname with the FQDN of your MySQL host. And test the connection which MUST succeed to be able to install correctly Ranger. I have used a simple password Please revert
... View more
