tasks/config_mariadb.yml

   1 - name: Etckeeper commit if necessary
   2   ansible.builtin.command: etckeeper commit "commit by ansible because installing {{ DOMAIN }}/{{ SITE }}"
   3   ignore_errors: true
   4
   5 - name: Install ansible mysql required packages
   6   ansible.builtin.apt:
   7     name:
   8       - python3-pymysql
   9
  10 - name: Boucle d'ajout du user php dans plusieurs groupe
  11   ansible.builtin.user:
  12     name: "php_{{ SIGLE }}_{{ SITE }}"
  13     groups: "{{ item }}"
  14     append: true
  15   loop:
  16     - mysql
  17     - "site_{{ SIGLE }}_{{ SITE }}"
  18
  19 - name: Création de la nouvelle bdd Mariadb
  20   community.mysql.mysql_db:
  21     name: "php_{{ SIGLE }}_{{ SITE }}"
  22     state: present
  23     login_unix_socket: /run/mysqld/mysqld.sock
  24     encoding: utf8mb4  # pour WP
  25
  26 - name: Créer le user mysql
  27   community.mysql.mysql_user:
  28     name: "php_{{ SIGLE }}_{{ SITE }}"
  29     priv: "php_{{ SIGLE }}_{{ SITE }}.*:ALL"
  30     state: present
  31     login_unix_socket: /run/mysqld/mysqld.sock