mysql数据库装包改密码脚本

#####################数据库装包改密#######################
#####################先准备mysql数据包及自动化安装包#######################
#!/bin/bash
systemctl restart firewalld
systemctl enable firewalld
firewall-cmd --set-default-zone=trusted
sed -i 's/=enforcing/=permissive/' /etc/selinux/config
setenforce 0
tar -xf mysql.tar.gz
cd 09.mysql
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
systemctl restart mysqld
systemctl enable mysqld
yum -y install expect.x86_64
###############取初始密码####################################
first_password=`awk '/root@localhost:/{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 root@localhost 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

转载于:https://blog.51cto.com/13587169/2074111