1.编写mysql函数脚本
#!/bin/bash
#关闭防火墙和selinux
systemctl stop firewalld && setenforce 0
#检查mysql并清理环境
check_mysql(){
echo "检查安装环境是否有mysql"
systemctl start mysqld &> /dev/null
if [ $? -eq 0 ];then
echo "已安装mysql"
exit 2
else
# rpm -qa |grep msyql
# find / -name mysql | xargs -i rm -rf {}
# rm -rf /etc/my.cnf
echo "按下面的操作进行"
exit
fi2
}
#下并安装载mysql rpm包
#rpm安装mysql
rpm_mysql(){
rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm && yum -y install yum-utils #安装yum工具包
if [ $? -eq 0 ];then
read -p "请选择mysql版本 " num
case $num in
5.5) yum-config-manager --enable mysql55-community echo"启用5.5"
yum-config-manager --disable mysql80-community ;; #禁用8.0
5.6) yum-config-manager --enable mysql56-community echo"启用5.6"
yum-config-manager --disable mysql80-community ;; #禁用8.0
5.7) yum-config-manager --enable mysql57-community echo"启用5.7"
yum-config-manager --disable mysql80-community ;; #禁用8.0
*) yum repolist all |grep mysql
echo"请选择版本"
;;
esac
else
echo "rpm包错重新下载"
exit 3
fi
}
#yum安装mysql服务
yum_mysql() {
yum install -y mysql-community-server &>/dev/null
if [ $? -eq 0 ];then
#启动mysql
systemctl start mysqld &>/dev/null
echo $?
#查看mysql服务状态
systemctl status mysqld &> /dev/null
echo "mysql安装成功"
exit 4
else
echo "mysql安装失败"
exit 5
fi
}
# 查看安装mysql的初始密码
grep_mysqlpass(){
grep 'temporary password' /var/log/mysqld.log
TEMP_PWD=$(grep 'temporary password' /var/log/mysqld.log)
PWD=${TEMP_PWD##* }
echo "${PWD}"
# 登录
mysql -uroot -p${PWD}
2.编写执行脚本
!/bin/bash
echo "这是msyql安装"
cat <<EOF
++++++++++++++++++++++++++++++++++
+ 1. 检查msyql是否安装 +
+ 2. 下载msyql_rpm包 +
+ 3. 安装mysql服务 +
+ 4. 查看mysql密码并登录 +
++++++++++++++++++++++++++++++++++
EOF
source /root/mysql.sh
read -p "按照要求安装并登录mysql:" login
case $login in
1)
check_mysql
;;
2)
rpm_mysql
;;
3)
yum_mysql
;;
4)
grep 'temporary password' /var/log/mysqld.log
TEMP_PWD=$(grep 'temporary password' /var/log/mysqld.log)
PWD=${TEMP_PWD##* }
echo "${PWD}"
# 登录
mysql -uroot -p${PWD}
exit 3
;;
esac