SRC_DIR=`pwd`

MYSQL='mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz'
#MYSQL='mysql-8.0.24-linux-glibc2.12-x86_64.tar.xz'
#MYSQL='mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz'

MYSQL_ROOT_PASSWORD=123456

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

. /etc/os-release

color () {
    RES_COL=60
    MOVE_TO_COL="echo -en \\033[${RES_COL}G"
    SETCOLOR_SUCCESS="echo -en \\033[1;32m"
    SETCOLOR_FAILURE="echo -en \\033[1;31m"
    SETCOLOR_WARNING="echo -en \\033[1;33m"
    SETCOLOR_NORMAL="echo -en \E[0m"
    echo -n "$1" && $MOVE_TO_COL
    echo -n "["
    if [ $2 = "success" -o $2 = "0" ] ;then
        ${SETCOLOR_SUCCESS}
        echo -n $"  OK  "    
    elif [ $2 = "failure" -o $2 = "1"  ] ;then 
        ${SETCOLOR_FAILURE}
        echo -n $"FAILED"
    else
        ${SETCOLOR_WARNING}
        echo -n $"WARNING"
    fi
    ${SETCOLOR_NORMAL}
    echo -n "]"
    echo 
}

check (){

if [ $UID -ne 0 ]; then
  color "当前用户不是root,安装失败" 1
  exit 1
fi

cd  $SRC_DIR


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

install_mysql(){
    $COLOR"开始安装MySQL数据库..."$END 
    if [ $ID = "centos" -o $ID = "rocky" ];then
        yum  -y -q install libaio numactl-libs ncurses-compat-libs
    elif [ $ID = "ubuntu" ];then
        apt update
        apt -y  install libtinfo5
    else
        color "不支持当前操作系统" 1
        exit
    fi
    if [ $? -eq 0 ];then
       color "安装相关包完成!" 0
    else
       color "安装相关包失败!" 1
       exit
    fi
    
    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 ; color "创建mysql用户" 0 ; }
        
    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]
server-id=`hostname -I|cut -d. -f4`
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
    [ -d /data ] || mkdir /data
  mysqld --initialize-insecure --user=mysql --datadir=/data/mysql 
    cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysqld
    if [ $ID = "centos" -o $ID = "rocky" ];then
        chkconfig --add mysqld
        systemctl start mysql
    else 
        systemctl enable  mysqld
        systemctl start mysql
    fi
    [ $? -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
  sleep 3
    mysqladmin  -uroot  password $MYSQL_ROOT_PASSWORD &>/dev/null
    color "数据库安装完成" 0
}


check

install_mysql