You can install MySQL 5.5 or later.
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
- 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.