2、实战：一键安装mysql-5.7二进制包脚本(mysql-5.7.29)(测试成功)

1、脚本位置

脚本测试成功，可一键部署。

脚本来源：LaoWang from magedu。

链接：https://pan.baidu.com/s/199YdkWnhBMKDUHcYUeEKSw?pwd=hems 提取码：hems

2024.4.6-实战：通用二进制格式安装 MySQL(mysql-5.7.29)-2024.4.6(测试成功)

脚本内容

mysql5.7.29_install.sh

#!/bin/bash

#MySQL5.7 Download URL: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
. /etc/init.d/functions 
SRC_DIR=`pwd`
MYSQL='mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz'
COLOR='echo -e \E[01;31m'
END='\E[0m'
MYSQL_ROOT_PASSWORD=magedu

check (){
if [ $UID -ne 0 ]; then
 action "当前用户不是root,安装失败" false
 exit 1
fi


cd $SRC_DIR
if [ ! -e $MYSQL ];then
    $COLOR"缺少${MYSQL}文件"$END
 	    $COLOR"请将相关软件放在${SRC_DIR}目录下"$END
    exit
elif [ -e /usr/local/mysql ];then
    action "数据库已存在，安装失败" false
    exit
else
 return
fi
}


install_mysql(){
  $COLOR"开始安装MySQL数据库..."$END
    yum -y -q install libaio numactl-libs  libaio &> /dev/null
  cd $SRC_DIR
  tar xf $MYSQL -C /usr/local/
  MYSQL_DIR=`echo $MYSQL| sed -nr 's/^(.*[0-9]).*/\1/p'`
  ln -s /usr/local/$MYSQL_DIR /usr/local/mysql
  chown -R root.root /usr/local/mysql/
  id mysql &> /dev/null || { useradd -s /sbin/nologin -r mysql ; action "创建mysql用户"; }
    
  echo 'PATH=/usr/local/mysql/bin/:$PATH' > /etc/profile.d/mysql.sh
   . /etc/profile.d/mysql.sh
  cat > /etc/my.cnf <<-EOF
[mysqld]
server-id=1
log-bin
datadir=/data/mysql
socket=/data/mysql/mysql.sock                          
                        
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
[client]
socket=/data/mysql/mysql.sock
EOF

   mkdir -p /data/mysql
   chown mysql:mysql /data/mysql
  mysqld --initialize --user=mysql --datadir=/data/mysql 
  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
  chkconfig --add mysqld
  chkconfig mysqld on
  service mysqld start
  [ $? -ne 0 ] && { $COLOR"数据库启动失败，退出!"$END;exit; }
  MYSQL_OLDPASSWORD=`awk '/A temporary password/{print $NF}' /data/mysql/mysql.log`
  mysqladmin -uroot -p$MYSQL_OLDPASSWORD password $MYSQL_ROOT_PASSWORD &>/dev/null
  action "数据库安装完成"
}

check

install_mysql

测试环境

mysql-5.7.29
centos7.6 1810

2、使用方法

把安装包、脚本传到linux机器，一键执行脚本即可。

测试效果(符合预期)

[root@vm-template ~]#netstat -antlp|grep mysql
tcp6       0      0 :::3306                 :::*                    LISTEN      17705/mysqld        
[root@vm-template ~]#mysql -uroot -pmagedu
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> \q
Bye
[root@vm-template ~]#