前言

这两天一直在搭建mysql,一直遇到安装mysql的问题,为了解决重复安装的问题,决定写mysql的一键启动脚本

目前mysql脚本更新到了第二版

#/bin/bash
#version: v1
#author: YK

#安装mysql5.7
#清除旧安装包
echo "mysql的rpm包存放路径:"
read rpm_where
locate=${rpm_locate:-"/root/"}
echo "mysql的rpm包存放路径:$locate"

echo "mysql密码:"
read secret_n
secret_new=${secret_n:-"MyStr0ngP@ssw0rd!"}
echo "mysql密码:$secret_new"

echo "正在删除旧安装包"
rpm -qa|grep mysql |xargs yum remove -y >&/dev/null
rpm -qa|grep mariadb |xargs yum remove -y >&/dev/null
rpm -qa|grep mysql|xargs rpm -e >&/dev/null
rm -rf /var/lib/mysql/*
rm -f /var/log/mysqld.log


#安装
echo "正在安装"
cd $rpm_where
yum -y install libaio net-tools >&/dev/null
tar -xf mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar.gz
rpm -ivh mysql-community-common-5.7.44-1.el7.x86_64.rpm >&/dev/null
rpm -ivh mysql-community-libs-5.7.44-1.el7.x86_64.rpm >&/dev/null
rpm -ivh mysql-community-client-5.7.44-1.el7.x86_64.rpm >&/dev/null
rpm -ivh mysql-community-server-5.7.44-1.el7.x86_64.rpm >&/dev/null
rm ./mysql-community* -rf

#启动
mysql_run=0
echo "正在启动mysql"
while [ "$mysql_run" -ne 1 ]
do
   mysql_run=$(systemctl status mysqld|grep running |wc -l)
   systemctl start mysqld
   sleep 10
done

echo "myslq已启动"


#改密码
secret_old=\'$(grep 'temporary password' /var/log/mysqld.log|awk  '{print $NF}'| tr -d ';')\'
sleep 3
echo "mysqladmin -u root -p$secret_old password 'MyStr0ngP@ssw0rd!' &>/dev/null" 
echo "mysql -uroot -p'MyStr0ngP@ssw0rd!'"