ansible_roles_webcluster/roles/web_db/tasks/main.yml

---
- name: Install software
  package:
    name: "{{ item }}"
    state: present
  with_items: "{{ db_packages }}"

- name: MariaDB enable service
  service:
    name: "{{ db_servicename }}"
    state: started
    enabled: yes

- name: MariaDB create DB
  mysql_db:
    name: "{{ db_name }}"
    state: present

- name: MariaDB create user
  mysql_user:
    name: "{{ db_user }}"
    password: "{{ db_password }}"
    priv: '{{ db_name }}.*:ALL'
    host: '%'
    state: present