#!/bin/bash

# 配置mysql yum源
wget https://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
rpm -ivh mysql57-community-release-el7-7.noarch.rpm

# 更新GPG驗證密鑰，并安裝mysql，如果不更新密鑰，安裝則會失敗
# 如果不更新最后兩行可能報以下錯誤
# Failing package is: mysql-community-client-5.7.38-1.el7.x86_64
# GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install mysql-server -y

# 啟動mysql
echo '正在啟動MySQL，請稍等......'
systemctl start mysqld.service
if [ $? -ne 0 ];then
? ?echo 'MySQL啟動失敗!!!'
? ?exit
else
? ?echo 'MySQL啟動成功！??！'
? ?echo '===================================='
fi


# 獲取初始密碼
initpasswd=`cat /var/log/mysqld.log | grep password | awk '{print $NF}'`
echo "初始密碼為：${initpasswd}"

# 用戶設(shè)置密碼
flag=1
while [ $flag -eq 1 ]
do
?? ?read -p "請輸入新密碼：" ?newpasswd
?? ?read -p "請確認(rèn)密碼：" ?secondpasswd
? ? if [ $newpasswd -eq $secondpasswd ]
? ? then
?? ?flag=2
? ? else
?? ?echo "兩次密碼不一致，請重新輸入"
?? ?echo "===================================="
? ? fi
done

echo "設(shè)置的新密碼為：${newpasswd}"

mysql --connect-expired-password -uroot -p"${initpasswd}" -e "set global validate_password_policy=0;set global validate_password_length=1;alter user 'root'@'localhost' identified by '${newpasswd}';"

if [ $? -ne 0 ];then
? ?echo '新密碼設(shè)置失敗!!!'
? ?exit
else
? ?echo '===================================='
? ?echo "新密碼設(shè)置成功!，新密碼為：${newpasswd}"
? ?echo '===================================='
fi

echo "正在開啟遠(yuǎn)程登錄......"
mysql --connect-expired-password -uroot -p"${newpasswd}" -e "update mysql.user set Host = '%' where Host = 'localhost' and User='root';flush privileges;"
if [ $? -ne 0 ];then
? ?echo '遠(yuǎn)程登錄開啟失敗!!!'
? ?exit
else
? ?echo '===================================='
? ?echo '遠(yuǎn)程登錄開啟成功!'
? ?echo '===================================='
fi