Installing MySQL
About This Task
You can install MySQL 5.5 or later.
Before You Begin
On the Ambari host, install the JDBC driver for MySQL, and then add it to Ambari:
yum install mysql-connector-java* \ sudo ambari-server setup --jdbc-db=mysql \ --jdbc-driver=/usr/share/java/mysql-connector-java.jar
Steps
Log in to the node on which you want to install the MySQL metastore to use for SAM, Schema Registry, and Druid.
Install MySQL and the MySQL community server, and start the MySQL service:
yum localinstall \ https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm yum install mysql-community-server systemctl start mysqld.service
Obtain the randomly generated MySQL root password.
grep 'A temporary password is generated for root@localhost' \ /var/log/mysqld.log |tail -1
Reset the MySQL root password. Enter the following command. You are prompted for the password you obtained in the previous step. MySQL then asks you to change the password.
/usr/bin/mysql_secure_installation