- ##################### 数据库装包改密码 #######################
- #!/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 /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
来源: http://www.bubuko.com/infodetail-2510942.html