main.yml

---
# 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