--- # file: roles/mysql/tasks/main.yml - name: ensure mysql packages are installed for jessie apt: name: - mysql-server - python-mysqldb state: present when: - debian_version == "jessie" tags: - packages - mysql - name: ensure mysql packages are installed for stretch apt: name: - mariadb-server - python-mysqldb state: present when: - debian_version != "jessie" tags: - packages - mysql - name: ensure mysql is started service: name: mysql state: started enabled: true tags: - service - mysql - name: ensure the mysql root user exists and has the correct password mysql_user: name: root password: "{{ mysql_root_password }}" login_user: root login_password: "{{ mysql_root_password }}" register: mysql_root_creation_result no_log: true ignore_errors: true tags: - mysql - config - name: initialize the mysql root user mysql_user: name: root password: "{{ mysql_root_password }}" no_log: true when: mysql_root_creation_result|failed tags: - mysql - config