homelab_flarum/roles/flarum/tasks/setup_mariadb.yml

---
- name: Update sudoers
  become: yes
  community.general.sudoers:
    name: do-as-mysql
    state: present
    user: "{{ ansible_user }}"
    runas: mysql
    commands: ALL
- name: Install MariaDB Server
  become: yes
  package:
    name: mariadb
    state: latest
- name: Start MariaDB server
  become: yes
  systemd:
    name: mariadb
    enabled: yes
    state: started
- name: Create flarum_user with password for MariaDB
  become: yes
  become_user: mysql
  mysql_user:
    name: flarum_user
    login_user: mysql
    password: "{{ flarum_db_pass }}"
    state: present
    priv: "*.*:ALL"
- name: Create flarum database
  become: yes
  become_user: mysql
  mysql_db:
    name: flarum
    login_user: flarum_user
    login_password: "{{ flarum_db_pass }}"