rh358/database-auto/configure_users.yml

---
- name: Configure users in MariaDB
  hosts: db_servers
  become: yes

  tasks:
    - name: Create users and set password if not present
      mysql_user:
        name: "{{ item['name']  }}"
        update_password: on_create
        password: "{{ item['password'] }}"
        state: present
      loop: "{{ mysql_user_passwords }}"

    - name: Configure users in MariaDB inventory
      mysql_user:
        name: "{{ item['name'] }}"
        host: "{{ item['host'] }}"
        priv: "{{ item['priv'] }}"
        state: "{{ item['state'] }}"
      loop: "{{ mysql_users }}"

    - name: Update users with password for all host
      mysql_user:
        name: "{{ item['name'] }}"
        host_all: yes
        update_password: always
        password: "{{ item['password'] }}"
        state: present
      loop: "{{ mysql_user_passwords }}"