tasks/config_mariadb.yml

   1 - name: Boucle d'ajout du user php dans plusieurs groupe
   2   ansible.builtin.user:
   3     name: "php_{{ SIGLE }}_{{ SITE }}"
   4     groups: "{{ item }}"
   5     append: true
   6   loop:
   7     - mysql
   8     - "site_{{ SIGLE }}_{{ SITE }}"
   9
  10 - name: Création de la nouvelle bdd Mariadb
  11   community.mysql.mysql_db:
  12     name: "php_{{ SIGLE }}_{{ SITE }}"
  13     state: present
  14     login_unix_socket: /run/mysqld/mysqld.sock
  15     encoding: utf8mb4  # pour WP
  16
  17 - name: Créer le user mysql
  18   mysql_user:
  19     name: "php_{{ SIGLE }}_{{ SITE }}"
  20     priv: "php_{{ SIGLE }}_{{ SITE }}.*:ALL"
  21     state: present
  22     login_unix_socket: /run/mysqld/mysqld.sock