mysql資料庫裝包改密碼指令碼

標籤：營運

#####################資料庫裝包改密碼#######################

#!/bin/bash
firewall-cmd --set-default-zone=trusted
setenforce 0
#tar -xf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
rm -rf mysql-community-server-minimal-5.7.17-1.el7.x86_64.rpm
yum -y install perl-Data-Dumper.x86_64 perl-JSON.noarch perl-JSON-PP.noarch
rpm -Uvh mysql-community-*.rpm --nodeps
systemctl restart mysqld
systemctl enable mysqld
yum -y install expect.x86_64
###############取初始密碼####################################
first_password=\‘awk ‘/[email protected]:/{print $11}‘ /var/log/mysqld.log\‘
expect << EOF
spawn mysql -uroot -p$first_password
expect "mysql>" {send "set global validate_password_policy=0;\n"}
expect "mysql>" {send "set global validate_password_length=6;\n"}
expect "mysql>" {send "alter user [email protected] identified by \"123456\";\n"}
expect "mysql>" { send "quit\n"}
EOF
sed -i ‘/^[mysqld]/avalidate_password_policy=0‘ /etc/my.cnf
sed -i ‘/^[mysqld]/avalidate_password_length=6‘ /etc/my.cnf
systemctl restart mysqld

mysql資料庫裝包改密碼指令碼