#!/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
Linux(Centos7.9)下mysql5.7/8 installation shell
最新推荐文章于 2024-09-30 09:51:27 发布