centos 7 MySQL8 离线一键自动安装脚本

#!/bin/bash # ***************************************************************** # * ANHUI DAHONG INTELLIGENT TECHNOLOGY CO.,LTD,All Rights Reserved # * Copyright (C) 2014-2024 # * @Title: MySQL一键自动安装脚本 # * @Author: 李立正 # * @Version: v1.2.1 # * @Date: 2024/04/03 # * @Description: 离线环境下 # * v1.0.centos 7 环境下MySQL一键安装自动化脚本 # * v1.2.脚本优化成函数形式，增加可读性，Main函数执行安装流程 # * v1.2.1 拆分到单独的mysql安装并测试 # ***************************************************************** set -e MYSQL_PACKAGE="/usr/local/dhtech/autoinstall/lib/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz" MYSQL_INSTALL_DIR="/usr/local/dhtech/mysql" MYSQL_DATA_DIR="/dhxdata/mysql" MYSQL_SOCKET_DIR="/usr/local/dhtech/mysql/socket" MYSQL_SOCKET_FILE="$MYSQL_SOCKET_DIR/mysql13306.sock" MYSQL_PASSWORD="dhtech@2023#YN" MYSQL_NEW_USER="mysql_yn" MYSQL_NEW_USER_PASSWORD="YN@2023" MySQL_PORT="13306" DEPENDENCY_DIR="/usr/local/dhtech/autoinstall/third-lib/" install_dependencies() { echo "安装依赖..." yum localinstall -y "$DEPENDENCY_DIR/ncurses-devel"/*.rpm yum localinstall -y "$DEPENDENCY_DIR/libaio-devel"/*.rpm } setup_mysql_account() { echo "创建MySQL用户和组..." groupadd mysql useradd -r -g mysql -s /bin/false mysql } setup_directories() { echo "创建目录并设置权限..." mkdir -p "$MYSQL_INSTALL_DIR" mkdir -p "$MYSQL_DATA_DIR" mkdir -p "$MYSQL_SOCKET_DIR" chown -R mysql:mysql "$MYSQL_INSTALL_DIR" chown -R mysql:mysql "$MYSQL_DATA_DIR" chown -R mysql:mysql "$MYSQL_SOCKET_DIR" } install_mysql() { echo "解压并安装MySQL..." tar -xf "$MYSQL_PACKAGE" --strip-components=1 -C "$MYSQL_INSTALL_DIR" } configure_mysql() { echo "将MySQL可执行文件添加到系统路径..." echo "export PATH=\$PATH:$MYSQL_INSTALL_DIR/bin" >> /etc/profile source /etc/profile echo "设置MySQL配置文件" cat << EOF > /etc/my.cnf [mysqld] user=mysql basedir=$MYSQL_INSTALL_DIR datadir=$MYSQL_DATA_DIR socket=$MYSQL_SOCKET_FILE port=$MySQL_PORT sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci EOF } setup_service() { echo "创建MySQL服务并设置为开机自启..." cat << EOF > /etc/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.target [Service] User=mysql Group=mysql ExecStart=$MYSQL_INSTALL_DIR/bin/mysqld --defaults-file=/etc/my.cnf ExecReload=/bin/kill -s HUP $MAINPID Restart=on-failure [Install] WantedBy=multi-user.target EOF systemctl daemon-reload systemctl start mysqld systemctl enable mysqld } initialize_mysql() { echo "初始化MySQL，并获取初始Root密码..." $MYSQL_INSTALL_DIR/bin/mysqld --initialize --user=mysql --basedir=$MYSQL_INSTALL_DIR --datadir=$MYSQL_DATA_DIR > mysql_init.log 2>&1 } main() { if [[ $EUID -ne 0 ]]; then echo "该脚本必须以root身份运行" exit 1 fi if [ ! -f "$MYSQL_PACKAGE" ]; then echo "MySQL安装包不存在." exit 1 fi install_dependencies setup_mysql_account setup_directories install_mysql configure_mysql setup_service initialize_mysql TEMP_PASSWORD=$(awk '/temporary password/{print $NF}' mysql_init.log) echo "MySQL临时Root密码: $TEMP_PASSWORD" echo "等待MySQL服务启动..." until mysqladmin ping --socket=$MYSQL_SOCKET_FILE --silent; do sleep 1 echo "等待MySQL启动..." done echo "重置MySQL Root密码..." mysql --user=root --password="$TEMP_PASSWORD" --connect-expired-password --socket=$MYSQL_SOCKET_FILE <<EOF ALTER USER 'root'@'localhost' IDENTIFIED BY '$MYSQL_PASSWORD'; EOF echo "创建新的MySQL用户并授予所有权限..." mysql --user=root --password="$MYSQL_PASSWORD" --socket=$MYSQL_SOCKET_FILE <<EOF CREATE USER '$MYSQL_NEW_USER'@'%' IDENTIFIED BY '$MYSQL_NEW_USER_PASSWORD'; GRANT ALL PRIVILEGES ON *.* TO '$MYSQL_NEW_USER'@'%'; EOF echo "MySQL已经安装并启动，端口为$MySQL_PORT！" # 在防火墙中添加MySQL端口 firewall-cmd --zone=public --add-port=$MySQL_PORT/tcp --permanent firewall-cmd --reload } main "$@"