一键安装mysql5.7和mysql8.0二进制包的脚本

【摘要】 离线安装脚本
[root@cent8_yzil ~]# cat install_mysql5.7or8.0_for_centos.sh #!/bin/bash. /etc/init.d/functionsSRC_DIR=`pwd`#MYSQL=’mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz’MYSQL=’mysql-8.0.23-li…

离线安装脚本

      [root@cent8_yzil ~]# cat install_mysql5.7or8.0_for_centos.sh 

      #!/bin/bash

      . /etc/init.d/functions

      SRC_DIR=`pwd`

      #MYSQL='mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz'

      MYSQL='mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz'

      COLOR='echo -e \E[01;31m'

      END='\E[0m'

      MYSQL_ROOT_PASSWORD=redhat

      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

       ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

       mkdir -p /data/mysql

       id mysql &> /dev/null || { useradd -s /sbin/nologin -r  mysql ; action "创建mysql用户"; }

       chown mysql.mysql /data/mysql

       chown -R mysql.mysql /usr/local/mysql/

      echo 'PATH=/usr/local/mysql/bin/:$PATH' > /etc/profile.d/mysql.sh

       .  /etc/profile.d/mysql.sh

      	ln -s /usr/local/mysql/bin/* /usr/bin/

       cat > /etc/my.cnf <<-EOF

      [mysqld]

      user=mysql

      server-id=1

      basedir=/usr/local/mysql

      datadir=/data/mysql

      socket=/data/mysql/mysql.sock

      log-error=/data/mysql/mysql.log

      pid-file=/data/mysql/mysql.pid

      character-set-server=utf8mb4

      [client]

      socket=/data/mysql/mysql.sock

      default-character-set=utf8mb4

      prompt="\\r:\\m:\\s(\\u@\\h) [\\d]>\\_" #修改提示符

      #!includedir /etc/my.cnf.d

      EOF

         cat > /etc/systemd/system/mysqld.service <<-EOF

      [Unit]

      Description=MySQL Server

      After=network.target

      After=syslog.target

      [Install]

      WantedBy=multi-user.target

      [Service]

      User=mysql

      Group=mysql

      ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf

      EOF

       mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

       systemctl enable --now mysqld

       [ $? -ne 0 ] && { $COLOR"数据库启动失败，退出!"$END;exit; }

       sleep 5

       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

      [root@cent8_yzil ~]# 

  


                    
        
© 版权声明
文章版权归作者所有，未经允许请勿转载。
THE END
数据库