centos7一键安装mysql并开放远程访问

脚本如下（install_mysql.sh 此脚本需要以root用户身份运行）

vim install_mysql.sh

#!/bin/bash

# 检查是否为root用户
if [ "$(id -u)" != "0" ]; then
    echo "请以root用户身份运行此脚本。" 1>&2
    exit 1
fi

# 检查参数
if [ $# -ne 1 ]; then
    echo "用法: $0 <MySQL密码>"
    exit 1
fi

new_password=$1

# 安装EPEL仓库
yum -y install epel-release

# 安装MySQL 5.7
yum -y install https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-community-server

# 启动MySQL并设置开机自启
systemctl start mysqld
systemctl enable mysqld

# 获取临时密码
temp_password=$(grep "A temporary password" /var/log/mysqld.log | awk '{print $NF}')

# 创建MySQL配置文件
cat > /root/mysql_secure_installation.sql << EOF
# 修改root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '${new_password}';
# 创建可以从任何主机访问的用户
CREATE USER 'root'@'%' IDENTIFIED BY '${new_password}';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
# 删除匿名用户
DELETE FROM mysql.user WHERE User='';
# 删除远程root用户
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
# 删除test数据库
DROP DATABASE IF EXISTS test;
# 删除test数据库的权限
DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
# 刷新权限
FLUSH PRIVILEGES;
EOF

# 使用临时密码登录MySQL并运行配置文件
mysql -uroot -p"${temp_password}" --connect-expired-password < /root/mysql_secure_installation.sql

# 删除配置文件
rm -f /root/mysql_secure_installation.sql

# 修改bind-address
sed -i "s/^bind-address.*=.*$/bind-address = 0.0.0.0/" /etc/my.cnf

# 增加max_allowed_packet设置
echo "max_allowed_packet=32M" >> /etc/my.cnf

# 重启MySQL以应用更改
systemctl restart mysqld

echo "MySQL已成功安装并设置密码，已开启远程访问"

使用方法：

chmod +x install_mysql.sh
./install_mysql.sh Your_New_Password