mysql.yml 575 B

1234567891011121314
  1. - name: Install mysql-server related packages
  2. apt: pkg={{ item }} state=installed update_cache=yes
  3. with_items:
  4. - mysql-server
  5. - automysqlbackup
  6. when: with_mysql
  7. - name: Change mysql root default password
  8. raw: if "SELECT VERSION();" | mysql -u root >/dev/null 2>&1 ; then echo "UPDATE mysql.user SET Password=PASSWORD('{{ mysql_root_password }}') WHERE User IN ('', 'root'); FLUSH PRIVILEGES;" | mysql --defaults-file=/etc/mysql/debian.cnf ; fi
  9. when: with_mysql
  10. - name: Ensure mysql-server is running
  11. service: name=mysql state=started
  12. when: with_mysql