mysql5.7安装脚本

在root用户下创建mysqlinstall.sh

然后vim mysqlinstall.sh 编辑脚本

将如下信息粘贴进去

sh mysqlinstall.sh    执行脚本即可

脚本内容如下：

#!/bin/bash
#
echo "mysql5.7开始安装"
###关闭selinux和防火墙###
setenforce 0
sed -i 's/'SELINUX=enforcing'/'SELINUX=disabled'/' /etc/selinux/config
systemctl stop firewalld.service
systemctl disable firewalld.service

###安装mysql5.7的yum源###
mkdir software
cd software
wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm

###安装mysql###
yum -y install mysql mysql-server mysql-devel
service mysqld start

###设置mysql的密码##
passwordmysql=`grep 'password' /var/log/mysqld.log |head -n 1|awk  {'print $11'}`
echo "请输入您想设置的mysqlroot密码："
read newpassword
mysql -uroot -p$passwordmysql --database mysql -e  "set global validate_password_policy=0; set global validate_password_length=1; SET PASSWORD = PASSWORD('$newpassword');" --connect-expired-password
echo "root用户密码为：$newpassword" >>passwordinformation.txt
 
###是否开启远程连接权限###
privilege(){
echo "是否开启远程连接权限（Y/N）："
read answer
if [ "$answer" = "N" ];then
    echo ""
elif [ "$answer" = "Y" ];then
    mysql -uroot -p$newpassword -e "grant all privileges on *.* to 'root'@'%' identified by '$newpassword';"
else 
    echo "输入错误，请输入大写的Y或者N"
    privilege
fi
}
privilege

###是否新建用户###
newuser(){
echo "是否新建用户（Y/N）："
read answer2
if [ "$answer2" = "N" ];then
    echo ""
elif [ "$answer2" = "Y" ];then
    echo "请输入新建用户的名字："
    read name1
    echo "请输入新建用户的密码："
    read password1
    mysql -uroot -p$newpassword -e "grant all privileges on *.* to '$name1'@'%' identified by '$password1';"
    echo "$name1用户密码为：$password1" >>passwordinformation.txt
else
    newuser    
fi
}
newuser

echo "安装完毕，账户信息存放于当前目录的passwordinformation.txt文件中，记录后请删除，以免信息泄露"