#!/bin/bash
#Author:小黑要上天
#Date:2023/6
#Description:mysql5.7/8 installation
#Prerequisite:被安装服务器需要能联网

#功能菜单
function_menu()
{
  clear
  echo -e "\033[44m功能菜单\033[0m"
  echo "1.安装mysql5.7"
  echo "2.安装mysql8"
  echo "3.退出"
  read -p "请输入对应功能菜单选项：" choice
  case $choice in
  1)
  function_mysql57
  ;;
  2)
  function_mysql8
  ;;
  3)
  exit
  ;;
  *)
  echo "功能菜单选项错误，请重新输入"
  sleep 0.5
  function_menu
  ;;
  esac
}

#环境变量初始化
function_environment()
{
  # 清除系统原有的MySQL环境
  rm -rf /var/run/yum.pid && yum remove mysql* -y  && yum remove mariadb* -y 
  find / -name mysql -exec rm -rf {} \;

## 删除原有的MySQL包
  for i in `rpm -qa |grep mysql`
  do
  rpm -e --nodeps $i
  done 
# 设置系统环境
  iptables -F
  setenforce 0
}

#安装mysql5.7
function_mysql57()
{
  function_environment
  if [ ! -d  "/tools" ];then
  mkdir /tools
  fi
  cd /tools
  rm -rf *
  rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
  wget https://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
  rm -rf /var/run/yum.pid
  rpm -ivh mysql57-community-release-el7-10.noarch.rpm
  yum -y install mysql-community-server

  systemctl start mysqld

  systemctl enable mysqld

# 检查 MySQL 是否运行
  mysqld_status=$(systemctl is-active mysqld)

  if [[ "$mysqld_status" == "active" ]]; then
    echo "MySQL is running"
  else
    echo "MySQL is not running"
  fi

## 获取MySQL初始密码
  initial_password="Root2#admin"
  pass=$(grep "password" /var/log/mysqld.log |tail -n1 |awk '{print $11}')

# 修改密码
  /usr/bin/mysqladmin -uroot -p${pass} password $initial_password

# MySQL 修改密码、创建数据库、刷新脚本，使用 EOF 命令
  mysql -uroot -p$initial_password -e "set global validate_password_length=6;set global validate_password_policy='LOW';FLUSH PRIVILEGES; "

# 获取上一条命令的退出状态
  MYSQL_COMMAND_STATUS=$?

# 判断命令执行状态
  if [ $MYSQL_COMMAND_STATUS -eq 0 ];then
    echo "mysql 安装和设置已经完成"
    echo "MySQL已经全部设置完毕，用户名为：root  密码为：$initial_password"
  else
    echo "MySQL 命令执行失败"
    echo "请检查MySQL"
  fi
}

#安装mysql8
function_mysql8()
{
  function_environment
  if [ ! -d "/tools" ];then
  mkdir /tools
  fi
  cd /tools
  rm -rf *
  wget https://repo.mysql.com/mysql80-community-release-el7-7.noarch.rpm
  rpm -ivh mysql80-community-release-el7-7.noarch.rpm

  rm -rf /var/run/yum.pid
  yum -y install mysql-community-server

  systemctl start mysqld

  systemctl enable mysqld

# 检查 MySQL 是否运行
  mysqld_status=$(systemctl is-active mysqld)

  if [[ "$mysqld_status" == "active" ]]; then
    echo "MySQL is running"
  else
    echo "MySQL is not running"
  fi

## 获取MySQL初始密码
  initial_password="Root2#admin"
  pass=$(cat /var/log/mysqld.log |grep password |awk '{print $13}'|tail -1)

# 修改密码
  /usr/bin/mysqladmin -uroot -p${pass} password $initial_password

# MySQL 修改密码、创建数据库、刷新脚本，使用 EOF 命令
  mysql -uroot -p$initial_password -e "set global validate_password.length=6;set global validate_password.policy='LOW';FLUSH PRIVILEGES; "

# 获取上一条命令的退出状态
  MYSQL_COMMAND_STATUS=$?

# 判断命令执行状态
  if [ $MYSQL_COMMAND_STATUS -eq 0 ];then
    echo "mysql 安装和设置已经完成"
    echo "MySQL已经全部设置完毕，用户名为：root  密码为：$initial_password"
  else
    echo "MySQL 命令执行失败"
    echo "请检查MySQL"
  fi
}

#main
function_menu