shell脚本批量设置mysql5.7 root密码
系统:centos 7.x(64位)
脚本内容:
cat /root/soft_shell/mysql_password_change.sh
02 | read -p "Enter mysql password" : newpasswd |
03 | sed -i "s/rocdk890/$newpasswd/g" /etc/init.d/mysqld_multi |
04 | chmod +x /etc/init.d/mysqld_multi |
05 | read -p "Number of mysql" : number |
06 | for i in $( seq 1 $number ); do |
07 | /usr/ local /mysql/bin/mysqld_multi --defaults-extra- file =/etc/my.cnf start ${i} |
08 | /usr/ local /mysql/bin/mysql -u root -S /data/mysql${i}/mysql.sock -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$newpasswd';" |
09 | /usr/ local /mysql/bin/mysql -u root -S /data/mysql${i}/mysql.sock -e "flush privileges;" |
12 | echo -e "\033[40;31mMySQL password-changing completed!\033[40;37m" |
ps:
本脚本只针对之前的一键安装多实例的脚本使用.
本脚本不能重置有root密码的mysql.
请大家注意这两点哦.
标签: mysql 设置 shell 密码 root password
评论: