Mysql8.0.21安装脚本

# Mysql8.0.21安装脚本
1. 脚本安装版本：8.0.21，如果需要更改版本，需要更新md5部分，及下载部分。
2. 如果需要更换数据文件保存位置，修改`datadir=`后的路径。
3. 脚本第133行会删除默认datadir路径下的所有文件，如果不是初次安装一定要注释或删除133行。

```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

# md5检查
mkdir -p $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
    yum -y install axel
    axel -n 10 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
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# log-error=/var/log/mysqld.log
# pid-file=/var/run/mysqld/mysqld.pid

# datadir=/database/MySQL/data
# socket=/database/MySQL/mysql.sock

# log-error=/database/MySQL/log/mysqld.log
# pid-file=/database/MySQL/mysqld.pid

# skip-grant-tables

#服务ID
server-id=1

#0为取消普通用户的只读模式，1为设置普通用户只读模式，该参数只能限定普通用户，对于有super权限的用户不生效，用户授权时要注意避免授予super权限，否则灾难级（all权限包含super权限，但super权限不包含all权限）
# read_only=1

#开启relay-log，指定存放路径及名称，若无此路径需手动创建，同时此路径需要mysql用户有权限写
# relay-log=/database/MySQL/relay-log/slave

#relay-log的索引目录及名称，若无此路径需手动创建，同时此路径需要mysql用户有权限写
# relay-log-index=/database/MySQL/relay-log/slave.index

#binlog文件存放路径及二进制日志文件索引目录，若无此路径需手动创建，同时此路径需要mysql用户有权限写
# log-bin=/database/MySQL/binlog/master-bin
# log-bin-index=/database/MySQL/binlog/master-bin.index

#binlog模式（默认开启row模式）
binlog_format=row

#binlog清理时间
expire_logs_days=7

#binlog每个日志文件大小
# max_binlog_size=500m

#binlog缓存大小
# binlog_cache_size=4m

#binlog最大缓存大小
max_binlog_cache_size=512m

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

[client]
# socket=/database/MySQL/mysql.sock
socket=/var/lib/mysql/mysql.sock
[mysql]
# socket=/database/MySQL/mysql.sock
socket=/var/lib/mysql/mysql.sock

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

```