---
- name: Install MariaDB Server & Client
  ansible.builtin.apt:
    name:
      - mariadb-server
      - mariadb-client
    state: present

- name: Start MariaDB Service
  ansible.builtin.service:
    name: mariadb
    state: started
    enabled: yes # Ensure the MariaDB service starts on boot

- name: Installer le client MySQL pour Python
  ansible.builtin.apt:
    name: python3-mysqldb
    state: present
    update_cache: yes

- name: create MySQL database
  mysql_db:
    check_implicit_admin: yes
    login_user: "{{ db_username }}"
    login_password: "{{ db_password }}"
    name: "{{ db_name }}"
    encoding: utf8mb4
    collation: utf8mb4_unicode_ci
    state: present

- name: create MySQL user
  mysql_user:
    name: "{{ db_username }}"
    password: "{{ db_password }}"
    priv: "{{ db_name }}.*:ALL,GRANT"
    state: present