CentOS Stream 9 专用 • MySQL 8.4.9 .tar.xz 压缩包全自动安装脚本纯离线通用包安装自动初始化、自动改密码、自动开远程自动加 systemd 开机自启无交互复制直接跑#!/bin/bashset-euopipefail# 配置项 MYSQL_VERSION8.4.9MYSQL_PACKAGEmysql-${MYSQL_VERSION}-linux-glibc2.28-x86_64MYSQL_TAR${MYSQL_PACKAGE}.tar.xzDOWNLOAD_URLhttps://cdn.mysql.com/Downloads/MySQL-8.4/${MYSQL_TAR}INSTALL_DIR/usr/local/mysqlDATA_DIR/data/mysqlMYSQL_CNF/etc/my.cnf# root 密码自行修改ROOT_PWDRoot123456# echo-e\033[32m 安装依赖 \033[0mdnfinstall-ylibaio-devel numactl openssl-develecho-e\033[32m 下载 MySQL${MYSQL_VERSION}\033[0mcd/usr/local/srcwget-N--show-progress$DOWNLOAD_URLecho-e\033[32m 解压 \033[0mtar-xf$MYSQL_TARmv$MYSQL_PACKAGE$INSTALL_DIRecho-e\033[32m 创建 mysql 用户 数据目录 \033[0mid-umysql/dev/null21||useradd-r-s/sbin/nologin mysqlmkdir-p$DATA_DIRchown-Rmysql:mysql$DATA_DIRchmod750$DATA_DIRecho-e\033[32m 生成 /etc/my.cnf \033[0mcat$MYSQL_CNFEOF [mysqld] user mysql basedir $INSTALL_DIRdatadir $DATA_DIRsocket /tmp/mysql.sock port 3306 character-set-server utf8mb4 default-storage-engine InnoDB max_connections 1000 bind-address 0.0.0.0 log_error $DATA_DIR/error.log pid-file $DATA_DIR/mysqld.pid EOFecho-e\033[32m 初始化 MySQL \033[0mrm-rf${DATA_DIR:?}/*${INSTALL_DIR}/bin/mysqld\--initialize-insecure\--usermysql\--datadir$DATA_DIR\--basedir$INSTALL_DIRecho-e\033[32m 配置 systemd 服务 \033[0mcat/usr/lib/systemd/system/mysqld.serviceEOF [Unit] DescriptionMySQL Server Afternetwork.target [Service] Usermysql Groupmysql Typeforking ExecStart$INSTALL_DIR/support-files/mysql.server start ExecStop$INSTALL_DIR/support-files/mysql.server stop Restarton-failure [Install] WantedBymulti-user.target EOFsystemctl daemon-reloadecho-e\033[32m 启动并开机自启 \033[0msystemctlenable--nowmysqldsleep3echo-e\033[32m 设置 root 密码 远程权限 \033[0m${INSTALL_DIR}/bin/mysql-uroot-e ALTER USER rootlocalhost IDENTIFIED BY ${ROOT_PWD}; CREATE USER IF NOT EXISTS root% IDENTIFIED BY ${ROOT_PWD}; GRANT ALL PRIVILEGES ON *.* TO root% WITH GRANT OPTION; FLUSH PRIVILEGES; echo-e\033[32m 加入全局 PATH \033[0mechoexport PATH\$PATH:$INSTALL_DIR/bin/etc/profile.d/mysql.shsource/etc/profile.d/mysql.shecho-e\033[32m 安装完成\033[0mecho版本信息:mysql-Vechoecho安装目录:$INSTALL_DIRecho数据目录:$DATA_DIRecho配置文件:$MYSQL_CNFechoroot密码:$ROOT_PWDecho登录命令: mysql -uroot -p$ROOT_PWDechoecho管理命令:echo systemctl start mysqldecho systemctl stop mysqldecho systemctl restart mysqld使用方法# 1. 创建脚本viminstall_mysql849.sh# 2. 粘贴上面全部内容保存# 3. 加执行权限chmodx install_mysql849.sh# 4. 运行./install_mysql849.sh安装完成后端口3306已开放远程 root 登录已设置开机自启直接使用mysql命令即可密码Root123456脚本里可改