---
- name: install dnf packages
  become: yes
  dnf:
    name: {{ item }}
    state: latest
  loop:
    - mariadb
    - mariadb-server
    - MySQL-python3
    - libselinux-python

- name: start and enabled mariadb
  become: yes
  systemd:
    name: mariadb
    state: restarted
    enabled: yes

- name:  create a database wordpress
  become: yes
  mysql_db:
    name: wordpress
    state: present
    encoding: utf8

- name:  create a MySQL user wordpress and give wordpress.* all privileges
  become: yes
  mysql_user:
    name: wordpress
    password: "hZzTwWuTeN"
    priv: "wordpress.*:ALL"
    host: localhost
    state: present