wwtou's blog 窝窝头-学技术

数据库服务之 Mysql8.x 服务脚本安装

/

Mysql介绍

MySQL是一个关系型数据库管理系统，由瑞典 MySQL AB 公司开发，属于 Oracle 旗下产品。MySQL是最流行的关系型数据库管理系统之一，在 WEB 应用方面，MySQL是最好的RDBMS (Relational Database Management System，关系数据库管理系统)应用软件之一。
MySQL是一种关系型数据库管理系统，关系数据库将数据保存在不同的表中，而不是将所有数据放在一个大仓库内，这样就增加了速度并提高了灵活性。
MySQL所使用的 SQL 语言是用于访问数据库的最常用标准化语言。MySQL 软件采用了双授权政策，分为社区版和商业版，由于其体积小、速度快、总体拥有成本低，尤其是开放源码这一特点，一般中小型和大型网站的开发都选择 MySQL作为网站数据库。
另外 MySQL8.0的生命周期[Apr 2026]，彻底绷不住了。直接安装MySQL8.4 LTS版本。


脚本内容：

  1. #!/bin/bash
  2. #
  3. #********************************************************************
  4. #Author:            wwtou
  5. #Date:                 2025-04-18
  6. #FileName：            Mysql_install_8x.sh
  7. #Description：        The test script for OS Version greater than 8.0
  8. #Copyright (C):     2020 All rights reserved
  9. #********************************************************************
  11. # Defined Variable
  12. MYSQL_VER="8.4.5"
  13. MYSQL_FILE="mysql-${MYSQL_VER}-linux-glibc2.28-x86_64.tar.xz"
  14. MYSQL_URL="https://cdn.mysql.com/archives/mysql-8.4/"
  15. SRC_DIR=/tools
  16. MYSQL_BASE_DIR="/app"
  17. MYSQL_INSTALL_DIR="${MYSQL_BASE_DIR}/mysql"
  18. MYSQL_DATA_DIR="/data/3306"
  19. MYSQL_BINLOG_DIR="/data/binlog"
  20. MYSQL_LOG_DIR="/data/log"
  21. MYSQL_CONFILE="/etc/my.cnf"
  22. MYSQL_COMMAND_FILE="/etc/profile.d/mysqld.sh"
  23. USER="mysql"
  24. GROUP="mysql"
  25. MYSQL_PORT=3306
  26. SERVERID=$(hostname -I | awk -F'.' '{print $4}' | cut -d' ' -f1)
  28. . /etc/os-release
  30. color() {
  31.     local text="$1"
  32.     local status="$2"
  33.     local RES_COL=60
  34.     local GREEN="\033[1;32m"
  35.     local RED="\033[1;31m"
  36.     local YELLOW="\033[1;33m"
  37.     local NORMAL="\033[0m"
  39.     # 左侧文本 + 对齐
  40.     printf "%-${RES_COL}s" "$text"
  42.     # 移动光标到第 RES_COL 列
  43.     echo -en "\033[${RES_COL}G"
  45.     echo -n "["
  46.     case "$status" in
  47.         success|0)
  48.             echo -en "${GREEN}  OK  ${NORMAL}"
  49.             ;;
  50.         failure|1)
  51.             echo -en "${RED}FAILED${NORMAL}"
  52.             ;;
  53.         *)
  54.             echo -en "${YELLOW}WARNING${NORMAL}"
  55.             ;;
  56.     esac
  57.     echo "]"
  58. }
  59. check () {
  60.     [ -e ${MYSQL_INSTALL_DIR} ] && { color "MYSQL SERVER 已安装,请卸载后再安装" 1; exit; }
  61.     [ ! -d ${MYSQL_BASE_DIR} ] && mkdir -p ${MYSQL_BASE_DIR}
  62.     [ ! -d ${MYSQL_DATA_DIR} ] && mkdir -p ${MYSQL_DATA_DIR}
  63.     [ ! -d ${MYSQL_BINLOG_DIR} ] && mkdir -p ${MYSQL_BINLOG_DIR}
  64.     [ ! -d ${MYSQL_LOG_DIR} ] && mkdir -p ${MYSQL_LOG_DIR}
  66.     color "检查操作系统和系统版本" 0
  67.     # Detect OS
  68.     # $os_version variables aren't always in use, but are kept here for convenience
  69.     if grep -qs "ubuntu" /etc/os-release; then
  70.         os="ubuntu"
  71.         os_version=$(grep 'VERSION_ID' /etc/os-release | cut -d '"' -f 2 | tr -d '.')
  72.     elif [[ -e /etc/debian_version ]]; then
  73.         os="debian"
  74.         os_version=$(grep -oE '[0-9]+' /etc/debian_version | head -1)
  75.     elif egrep -i "openeuler|rocky|almalinux|Anolis|centos|kylin" /etc/os-release &> /dev/null; then
  76.         os="centos"
  77.         os_version=$(grep  "VERSION_ID" /etc/os-release | awk -F'"' '{print $2}' | cut -d'.' -f1)
  78.     elif [[ -e /etc/fedora-release ]]; then
  79.         os="fedora"
  80.         os_version=$(grep -oE '[0-9]+' /etc/fedora-release | head -1)
  81.     else
  82.         color "This installer seems to be running on an unsupported distribution.Supported distros are Ubuntu, Debian, AlmaLinux, Rocky Linux, CentOS and Fedora." 1
  83.         exit
  84.     fi
  86.     if [[ "$os" == "ubuntu" && "$os_version" -lt 2204 ]]; then
  87.         color "Ubuntu 22.04 or higher is required to use this installer.This version of Ubuntu is too old and unsupported." 1
  88.         exit
  89.     fi
  90.     if [[ "$os" == "debian" ]]; then
  91.         if grep -q '/sid' /etc/debian_version; then
  92.             color "Debian Testing and Debian Unstable are unsupported by this installer." 1
  93.             exit
  94.         fi
  95.         if [[ "$os_version" -lt 11 ]]; then
  96.             color "Debian 11 or higher is required to use this installer.This version of Debian is too old and unsupported." 1
  97.             exit
  98.         fi
  99.     fi
  101.     if [[ "$os" == "centos" && "$os_version" -lt 9 ]]; then
  102.         os_name=$(grep  "^NAME" /etc/os-release | awk -F'"' '{print $2}')
  103.         echo "$os_name 9 or higher is required to use this installer.This version of $os_name is too old and unsupported." 0
  104.         exit
  105.     fi
  107.     color "安装工具包,检查防火墙" 0
  108.     if ! hash ufw 2>/dev/null && ! hash firewall-cmd 2>/dev/null && ! hash iptables 2>/dev/null; then
  109.         if [[ "$os" == "ubuntu" && "$os" == "debinn" ]]; then
  110.             apt -y update && apt install -y ufw
  111.             [ $? -ne 0 ] && { color "Install UFW Failed" 1 ; exit; }
  112.             ufw disable
  113.             color 'ufw is closed' 0
  114.         else
  115.             dnf install -y firewalld
  116.             [ $? -ne 0 ] && { color "Install Firewalld Failed" 1; exit; }
  117.             setenforce 0
  118.             sed -i '/^SELINUX=/c SELINUX=disabled' /etc/selinux/config
  119.             color 'Selinux has been disabled, and Permanent After Restarting' 0
  120.             systemctl disable --now  firewalld.service &>/dev/null
  121.             color 'firewalld is complete closed' 0
  122.         fi
  123.     fi
  125.     if [[ "$os" == "ubuntu" && "$os" == "debinn" ]]; then
  126.         apt -y update && apt install -y tar wget vim bash-completion gcc make openssl libssl-dev openssl-dev libaio-dev numactl
  127.         [ $? -ne 0 ] && { color "Install Tools Failed" 1 ; exit; }
  128.     else
  129.         dnf install -y wget tar vim-enhanced bash-completion gcc make openssl-devel libaio-devel numactl
  130.         [ $? -ne 0 ] && { color "Install Tools Failed" 1; exit; }
  131.     fi
  133.     [ ! -d ${SRC_DIR} ] && mkdir ${SRC_DIR}
  134.     cd  ${SRC_DIR}
  135.     if [  -e ${SRC_DIR}/${MYSQL_FILE} ];then
  136.         color "相关文件已准备好" 0
  137.     else
  138.         color '开始下载 MYSQL 源码包' 0
  139.         wget  ${MYSQL_URL}${MYSQL_FILE}
  140.         [ $? -ne 0 ] && { color "下载 ${MYSQL_FILE}文件失败" 1; exit; } 
  141.     fi
  142. } 
  144. install () {   
  145.     if id $USER  &> /dev/null;then
  146.         color "$USER 用户已存在" 1 
  147.     else
  148.         groupadd $GROUP
  149.         useradd -r -g $GROUP -s /sbin/nologin $USER
  150.         color "创建 $USER 用户" 0 
  151.     fi
  152.     chown -R $USER:$GROUP ${MYSQL_DATA_DIR} ${MYSQL_LOG_DIR} ${MYSQL_BINLOG_DIR}
  153.     echo
  154.     color "开始安装 MYSQL ===>>>" 
  155.     cd $SRC_DIR
  156.     tar -xvf ${MYSQL_FILE} -C ${MYSQL_BASE_DIR}
  157.     MYSQL_DIR=$(echo ${MYSQL_FILE} | sed -nr 's/^(.*[0-9]).*/\1/p')
  158.     #cd ${MYSQL_BASE_DIR}
  159.     #ln -s $(echo ${MYSQL_FILE} | sed -nr 's/^(.*[0-9]).*/\1/p') ${MYSQL_INSTALL_DIR}
  160.     ln -s ${MYSQL_BASE_DIR}/${MYSQL_DIR} ${MYSQL_INSTALL_DIR}
  162.     # initialized databases
  163.     ${MYSQL_INSTALL_DIR}/bin/mysqld --initialize-insecure --lower_case_table_names=1 --user=$USER --basedir=${MYSQL_INSTALL_DIR} --datadir=${MYSQL_DATA_DIR}
  165.     [ $? -eq 0 ] && color "MYSQL 初始化安装成功" 0 ||  { color "MYSQL 安装失败,退出!" 1 ;exit; }
  167.     # chown BaseDir and DataDir
  168.     chown -R $USER:$GROUP ${MYSQL_DATA_DIR} ${MYSQL_LOG_DIR} ${MYSQL_BINLOG_DIR}
  169.     chown -R $USER:root ${MYSQL_BASE_DIR}/${MYSQL_DIR}*
  171.     # configuration environment variable
  172.     echo "export PATH=${MYSQL_INSTALL_DIR}/bin:\$PATH" > ${MYSQL_COMMAND_FILE}
  174.     cat > ${MYSQL_CONFILE} <<EOF
  175. [mysql]
  176. socket = /tmp/mysql.sock
  177. default-character-set=utf8mb4
  179. [mysqld]
  180. user = $USER
  181. basedir = ${MYSQL_INSTALL_DIR}
  182. datadir = ${MYSQL_DATA_DIR}
  183. server_id = $SERVERID
  184. port = ${MYSQL_PORT}
  185. socket = /tmp/mysql.sock
  186. # 忽略大小写,加在在5.6/5.7低版本的mysql配置文件中有效. 8版本只能在初始化时指定,然后必须配置服务才能启动
  187. lower_case_table_names = 1  
  188. innodb_open_files = 1000
  189. #skip-log-bin = 1
  190. log-bin = ${MYSQL_BINLOG_DIR}/mysql-bin
  191. log-error = ${MYSQL_LOG_DIR}/error.log
  192. binlog_expire_logs_seconds = 604800
  193. max_binlog_size = 100M
  194. character-set-server = utf8mb4
  195. innodb_file_per_table = 1
  196. skip-name-resolve = 1
  197. innodb_strict_mode = 0
  198. #skip-grant-tables = 1
  199. max_allowed_packet = 1024M
  200. max_connections = 1000
  202. EOF
  204. if ! grep "* soft nofile 65535" /etc/security/limits.conf &>/dev/null; then
  205. cat <<-EOF >> /etc/security/limits.conf 
  206. * soft nofile 65535
  207. * hard nofile 65535
  208. EOF
  209. fi
  211.     cat > /usr/lib/systemd/system/mysqld.service <<EOF
  212. [Unit]
  213. Description=MySQL Server
  214. Documentation=man:mysqld(8)
  215. Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
  216. After=network.target
  217. After=syslog.target
  219. [Service]
  220. User=$USER
  221. Group=$GROUP
  222. ExecStart=${MYSQL_INSTALL_DIR}/bin/mysqld --defaults-file=${MYSQL_CONFILE}
  223. LimitNOFILE = 5000
  225. [Install]
  226. WantedBy=multi-user.target
  227. EOF
  229.     # start mysql serivce
  230.     systemctl daemon-reload && systemctl enable --now mysqld.service
  231.     sleep 10s
  233.     systemctl is-active mysqld &> /dev/null && color "MYSQL 服务启动成功!" 0 ||  { color "MYSQL 服务启动失败,退出!" 1 ; exit; }
  234.     color "MYSQL 安装完成" 0
  235.     echo
  236.     echo "请先运行: source ${MYSQL_COMMAND_FILE}"
  237.     echo
  238. }
  240. check
  241. installl

执行脚本

  1. bash mysql_install_v8.sh

通过执行脚本实现一键安装 ~~

转载请注明作者和出处，并添加本页链接。
原文链接: //www.wwtou.com/vGSSNZyy.html

下一篇：检测CPU微架构版本

上一篇：OpenSSL 生成CA证书和自签名证书

没有什么能够阻挡，你对自由的向往…

Copyright © 2025  窝窝头-学技术

Powered by zrlog, Themed by Robin L.

冀ICP备：2025109353号