12. MySQL-单机部署-5.6.48

1. 准备my.cnf配置文件

[mysqld]
user=mysql
datadir=/data/mysql
innodb_file_per_table=1
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid

2. 安装脚本

#!/bin/bash
#
#********************************************************************
#Author:            David
#QQ:                953260716
#Date:              2020-11-18
#FileName           install_mysql_5648.sh
#URL:               https://www.wangxiaoning.com
#Description        The test script
#Copyright (C):     2020 All rights reserved
#********************************************************************

DIR=$(pwd)
NAME='mysql-5.6.48-linux-glibc2.12-x86_64'
FULL_NAME="${DIR}/${NAME}.tar.gz"
DATA_DIR='/data/mysql'
#install dependency
echo "yum install dependencies"
sleep 2
echo "start to install"
sleep 2
yum -y remove mariadb-libs &> /dev/null
yum -y install perl-Getopt-Long libaio perl-Data-Dumper &> /dev/null
if [  $? -eq 0 ]; then
        echo "yum install succeed"
        echo "Proceeding"
        sleep 2
else
        echo "yum install failed,please check yum log"
        exit 4
fi
#check existence of install file and /usr/local/mysql file 
if [ -f ${FULL_NAME} ]; then
        echo "install_file exists!"
        sleep 2
        echo "Proceeding"
else
        echo "install_file doesn't exist!"
        echo "Please provide install_file and run again!"
        exit 4
fi
if [ -e /usr/local/mysql ]; then
        echo "MySQL may have been installed!"
        exit 4
else

    echo "Proceeding" 
    sleep 2
    tar xf ${FULL_NAME} -C /usr/local
    ln -s /usr/local/${NAME} /usr/local/mysql
    id mysql &> /dev/null  && echo "mysql user exists, skip user creation" || useradd -r -s /sbin/nologin mysql -d /data/mysql
    chown -R mysql.mysql /usr/local/mysql
    if [ ! -d /data/mysql ]; then
        mkdir -pv /data/mysql && chown -R mysql.mysql /data/mysql
        cd /usr/local/mysql
        ./scripts/mysql_install_db --datadir=/data/mysql --user=mysql --basedir=/usr/local/mysql
        cp /usr/local/${NAME}/support-files/mysql.server /etc/init.d/mysqld
        chmod a+x /etc/init.d/mysqld
        \cp ${DIR}/my.cnf /etc/my.cnf
        echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
        source /etc/profile.d/mysql.sh
        chkconfig --add mysqld
        service mysqld start
    else
        echo "MySQL data folder exists"
        exit 4
    fi
fi