Install 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 into the node where 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 a 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, followed by the password you obtained in the previous step. MySQL will ask you to change the password.
```
/usr/bin/mysql_secure_installation
```

​Install MySQL

Install MySQL