install mysql5.7 on Amazon Linux 2

readme.md

add MySQL Yum Repository

sudo amazon-linux-extras install epel
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum localinstall mysql80-community-release-el7-3.noarch.rpm

yum repolist enabled | grep "mysql.*-community.*" to check default mysql version

enable mysql5.7

sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community

install mysql5.7

yum update -y
yum install mysql57-community -y

run

systemctl start mysqld
systemctl enable mysqld

get temporary password and run mysql_secure_installation

grep 'password' /var/log/mysqld.log
mysql_secure_installation

add new user

mysql -p to connect locahost mysql

use mysql;
CREATE user 'admin'@'%' identified by 'password';
# GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' identified by 'password' with grant option;
flush privileges;