- name: Boucle d'ajout du user php dans plusieurs groupe
  ansible.builtin.user:
    name: "php_{{ SIGLE }}_{{ SITE }}"
    groups: "{{ item }}"
    append: true
  loop:
    - mysql
    - "site_{{ SIGLE }}_{{ SITE }}"

- name: Création de la nouvelle bdd Mariadb
  community.mysql.mysql_db:
    name: "php_{{ SIGLE }}_{{ SITE }}"
    state: present
    login_unix_socket: /run/mysqld/mysqld.sock
    encoding: utf8mb4  # pour WP

- name: Créer le user mysql
  mysql_user:
    name: "php_{{ SIGLE }}_{{ SITE }}"
    priv: "php_{{ SIGLE }}_{{ SITE }}.*:ALL"
    state: present
    login_unix_socket: /run/mysqld/mysqld.sock