CentOS7.6安装Mysql8

# CentOS7.6安装Mysql8
## install.sh脚本内容

```shell
#!/bin/bash
# By Hoiwan 20201211
WORKDIR=/opt/mysql8

function pre_install {
yum clean all
yum makecache
if [ -f /etc/yum.repos.d/epel.repo ] ; then
    yum -y install perl-Data-Dumper perl-JSON perl-Test-use-ok  wget
else
    yum install epel-release
    yum clean all
    yum makecache
    yum -y install perl-Data-Dumper perl-JSON perl-Test-use-ok wget
fi
mkdir $WORKDIR
cat > /opt/mysql8/md5 <<EOF
13241a900c23ba5b627668cd21c657d3  mysql-community-client-8.0.21-1.el7.x86_64.rpm
0a98775566e49ac494f418cd2950cc97  mysql-community-common-8.0.21-1.el7.x86_64.rpm
5ae112a9063d1abf60d32cfc4a2d8145  mysql-community-devel-8.0.21-1.el7.x86_64.rpm
872b84e71be8cb1c2f5b8fa95a09e7e4  mysql-community-embedded-compat-8.0.21-1.el7.x86_64.rpm
6569b86a78a303215bc089bbd13c4065  mysql-community-libs-8.0.21-1.el7.x86_64.rpm
961d893aada56f77472147c07986c13d  mysql-community-libs-compat-8.0.21-1.el7.x86_64.rpm
15447ab72889674f62252d5179ae27d7  mysql-community-server-8.0.21-1.el7.x86_64.rpm
9b5df1d3657b7a6bb71e0762c2daee34  mysql-community-test-8.0.21-1.el7.x86_64.rpm
EOF
cd $WORKDIR 
md5sum -c md5
if [ $? -eq 0 ] ; then
    tar xf mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
else
    wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar -o /opt/mysql8/mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
    tar xf mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar && md5sum -c md5 && echo "untar OK!"
fi

yum remove -y mariadb-libs
}

function install_mysql {
cd $WORKDIR 
rpm -ivh mysql-community-libs-8.0.21-1.el7.x86_64.rpm  mysql-community-libs-compat-8.0.21-1.el7.x86_64.rpm mysql-community-common-8.0.21-1.el7.x86_64.rpm mysql-community-embedded-compat-8.0.21-1.el7.x86_64.rpm mysql-community-devel-8.0.21-1.el7.x86_64.rpm mysql-community-server-8.0.21-1.el7.x86_64.rpm mysql-community-client-8.0.21-1.el7.x86_64.rpm
cat /dev/null > /var/log/mysqld.log
cat > /etc/my.cnf <<EOF
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
binlog_format=row
binlog_expire_logs_seconds=302400
max_binlog_size=500m
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names = 1
log_bin_trust_function_creators = 1
default_authentication_plugin = mysql_native_password
EOF

chown -R mysql.mysql /var/log/mysqld.log
rm -rf /var/lib/mysql/*

systemctl enable mysqld
systemctl start mysqld

MYPWD=`cat /var/log/mysqld.log |grep "A temporary password is generated" |awk '{print $13}'`
echo "Temporary password for root@localhost is $MYPWD"
echo "run 'mysql_secure_installation' to setup ur Database"
}

pre_install
cd $WORKDIR
md5sum -c md5
if [ $? -eq 0 ] ; then 
    echo "md5check OK!, begin installation."
    install_mysql
else
    echo "Run script under it's dir."
    exit 1
fi
```

## 安装方式

直接运行

```shell
bash install.sh
```