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.
/usr/bin/mysql_secure_installation
