YUM 方式

使用官方源安装

安装官方YUM源

# Download the yum rpm package
# official site: https://dev.mysql.com/downloads/repo/yum/

rpm -ivh https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

# Modify repo file
# enable MySQL5.7, disable MySQL8.0

sed -i '21s/0/1/' /etc/yum.repos.d/mysql-community.repo
sed -i '28s/1/0/' /etc/yum.repos.d/mysql-community.repo

# Rebuild yum cache

yum clean all
yum makecache

安装MySQL

yum install mysql-community-server -y

安全初始化MySQL

# 启动 MySQL 服务
systemctl start mysqld

# 启动后会在日志中生成临时密码，查看方式：
grep "temporary password" /var/log/mysqld.log

# 安全初始化
mysql_secure_installation

使用清华源安装

安装清华YUM源 ( MySQL 5.7 )

cat > /etc/yum.repos.d/mysql57-community-el7-tsinghua.repo << EOF
[mysql57-community]
name=MySQL 5.7 Community Server Tsinghua
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/
enabled=1
gpgcheck=1
gpgkey=http://repo.mysql.com/RPM-GPG-KEY-mysql
EOF

# Rebuild yum cache

yum clean all
yum makecache

安装MySQL

yum install mysql-community-server -y

# 若提示密钥问题则执行如下命令后再次执行安装命令
# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

安全初始化MySQL

# 启动 MySQL 服务
systemctl start mysqld

# 启动后会在日志中生成临时密码，查看方式：
grep "temporary password" /var/log/mysqld.log

# 安全初始化
mysql_secure_installation

一键安装 MySQL5.7 脚本

官方源

#!/bin/bash

. /etc/init.d/functions


# add yum repo
# Download the yum rpm package
# official site: https://dev.mysql.com/downloads/repo/yum/
rpm -i https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'add yum repo success' /bin/true
elif [ $? -eq 1 ]; then
    action 'yum repo is already installed' /bin/true
else
    action 'add yum repo failed' /bin/false
    exit 1
fi

# Modify repo file
# enable MySQL5.7, disable MySQL8.0
sed -i '21s/0/1/' /etc/yum.repos.d/mysql-community.repo
sed -i '28s/1/0/' /etc/yum.repos.d/mysql-community.repo


# rebuild yum cache
yum clean all > /dev/null 2>&1
yum makecache > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'rebuild yum cache success' /bin/true
else
    action 'rebuild yum cache failed' /bin/false
    exit 2
fi


# install MySQL
yum install mysql-community-server -y > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'install MySQL success' /bin/true
else
    action 'install MySQL failed' /bin/false
    exit 3
fi

清华源

#!/bin/bash

. /etc/init.d/functions


# add yum repo
cat > /etc/yum.repos.d/mysql57-community-el7-tsinghua.repo << EOF
[mysql57-community]
name=MySQL 5.7 Community Server Tsinghua
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/
enabled=1
gpgcheck=1
gpgkey=http://repo.mysql.com/RPM-GPG-KEY-mysql
EOF


# rebuild yum cache
yum clean all > /dev/null 2>&1
yum makecache > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'rebuild yum cache success' /bin/true
else
    action 'rebuild yum cache failed' /bin/false
    exit 1
fi


# install MySQL
yum install mysql-community-server -y > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'install MySQL success' /bin/true
else
    action 'install MySQL failed' /bin/false
    exit 2
fi

本地局域网源

#!/bin/bash

. /etc/init.d/functions


# add yum repo
cat > /etc/yum.repos.d/yum_local.repo << EOF
[yum_local]
name=yum_local
baseurl=http://192.168.1.61
enabled=1
gpgcheck=0
EOF


# rebuild yum cache
yum clean all > /dev/null 2>&1
yum makecache > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'rebuild yum cache success' /bin/true
else
    action 'rebuild yum cache failed' /bin/false
    exit 1
fi


# install MySQL
yum install mysql-community-server -y > /dev/null 2>&1
if [ $? -eq 0 ]; then
    action 'install MySQL success' /bin/true
else
    action 'install MySQL failed' /bin/false
    exit 2
fi

一键初始化 MySQL 脚本

#!/bin/bash

# 此脚本仅适用于yum方式安装的MySQL

systemctl start mysqld

temporary_password=`grep "temporary password" /var/log/mysqld.log | awk '{print $NF}'`


rpm -qa | grep expect > /dev/null 2>&1

if [ $? -ne 0 ]; then
    yum install expect -y > /dev/null 2>&1
fi


/usr/bin/expect << EOF
spawn mysql_secure_installation

expect "Enter password for user root:"
send "${temporary_password}\r"

expect "New password:"
send "NewPass0.0\r"

expect "Re-enter new password:"
send "NewPass0.0\r"

expect "Change the password for root ? ((Press y|Y for Yes, any other key for No) :"
send "n\r"

expect "Remove anonymous users? (Press y|Y for Yes, any other key for No) :"
send "y\r"

expect "Disallow root login remotely? (Press y|Y for Yes, any other key for No) :"
send "y\r"

expect "Remove test database and access to it? (Press y|Y for Yes, any other key for No) :"
send "y\r"

expect "Reload privilege tables now? (Press y|Y for Yes, any other key for No) :"
send "y\r"

expect eof

EOF

防火墙放行

firewall-cmd --permanent --add-service=mysql

firewall-cmd --reload

# 适需求而定