centos7 安装mysql5.7脚本

安装环境，centos7，安装mysql版本5.7

 

脚本使用说明

由于不支持附件文件，所以大家可以拷贝下面的脚本内容后粘贴到脚本文件中【例如文件名字: centos7_mysql.sh】

记得修改权限哟：

        sudo chmod a+x xxx.sh   

        sh xxx.sh  执行脚本进行安装

脚本中有设置默认的密码，记得调整成你自己要设置的密码

脚本内容如下

#!/bin/bash env
echo "Download msyql5.7 rpm..."
# mkdir temp dir to use download data
if [ ! -d "temp" ]; then
  echo "temp dir is not exits,create it!"
  sudo mkdir -p temp
fi

# install weget tools
sudo yum install wget -y
# dowload mysql5.7 to ../tmp/
wget -P temp -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

echo "Start to install mysql5.7..."
sudo yum -y install temp/mysql57-community-release-el7-10.noarch.rpm
sudo yum -y install mysql-community-server  

echo "启动mysql 服务"
sudo systemctl start mysqld.service

SQL_VERSION=`mysql -V | grep -i -o -P '5.7'`
if [ $SQL_VERSION == "5.7" ];then
    echo "check msyql install ok!"
else
    echo -e "\033[31m Msyql install error, Please install it manually \033[0m" 
    exit 0
fi

echo "msyql 临时密码:"
grep 'password' /var/log/mysqld.log |head -n 1 |grep -oE "localhost:(.+)$" | grep -i -o -P 'localhost: \K.+'


echo "try modify database use password"
# get mysql temp password
TEMP_PWD=`grep 'password' /var/log/mysqld.log |head -n 1 |grep -oE "localhost:(.+)$" | grep -i -o -P 'localhost: \K.+'`
echo $TEMP_PWD


# get mysql sock file 
SOCK=`netstat -ln | grep mysql | head -n 2 | awk '{print $9}'`
PORT="3306"
USER="root"
# modify set your ownpwd
PASSWORD="Wzyonaga_t2Gt"
WRAPPWD="\"Wzyonaga_t2Gt\""

# modify password  
mysql --connect-expired-password -p$TEMP_PWD -S $SOCK -e 'alter user user() identified by '$WRAPPWD

echo "modify database password ok!"
echo "new password: $PASSWORD"

学IT，上博学谷