ansible批量部署mysql

efn阿克说

/usr/bin/　　####复制mysql配置文件
　　cp -f /application/mysql/support-files/my-default.cnf /etc/my.cnf
　　####复制mysql启停脚本到init.d
　　cp -f /application/mysql/support-files/mysql.server /etc/init.d/mysqld
　　####执行权
　　chmod 700 /etc/init.d/mysqld
　　####初始化mysql
　　/application/mysql/scripts/mysql_install_db  --basedir=/application/mysql --datadir=$DBDIR --user=mysql
　　####如果mysql初始化失败提示install mysql is failed!  否则/etc/init.d/mysqld start
　　if [ $? -ne 0 ];then
　　echo "install mysql is failed!" && /bin/false
　　fi
　　/etc/init.d/mysqld start
　　####如果mysql开启失败提示install mysql is failed! 否则继续往下走
　　if [ $? -ne 0 ];then
　　echo "install mysql is failed!" && /bin/false
　　fi
　　####开机自启
　　chkconfig --add mysqld
　　chkconfig mysqld on
　　/application/mysql/bin/mysql -e "update mysql.user set password=password('$PASSWD') where host='localhost' and user=
　　'root';"
　　/application/mysql/bin/mysql -e "update mysql.user set password=password('$PASSWD') where host='127.0.0.1' and user=
　　'root';"
　　/application/mysql/bin/mysql -e "delete from mysql.user where password='';"
　　/application/mysql/bin/mysql -e "flush privileges;"
　　if [ $? -eq 0 ];then
　　echo "ins_done"
　　fi