在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文件中,记录后请删除,以免信息泄露"