install_mysql.sh

#!/usr/bin/env bash
# Configure script runtime settings
set -o errexit -o pipefail -o nounset
#set -o xtrace
#set -x
# Updating packages
echo Applying pending updates...
sleep 10
yum update -y
sleep 10
# Install common packages
yum install -y jq
sleep 10

amazon-linux-extras install -y epel
sleep 10
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum localinstall -y mysql57-community-release-el7-11.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y mysql-community-server

service mysqld start

AUTO_GENERATED_PASSWORD=$(sudo grep 'temporary password' /var/log/mysqld.log | sed 's/.* //')
echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '${MYSQL_ROOT_PASSWORD}'; FLUSH PRIVILEGES;" > /tmp/mysql-init.sql
mysql --connect-expired-password -u root -p$AUTO_GENERATED_PASSWORD < /tmp/mysql-init.sql
rm -rf /tmp/mysql-init.sql

chkconfig mysqld on