path: root/pad/tasks/mariadb.yml

---
- name: Install MySQL packages
  apt:
    name:
      - mariadb-server
      - mariadb-client
      - python3-mysqldb
- name: Start MariaDB
  service:
    name: mysql
    state: started
- name: Ensure emacsconf-pad database exists
  mysql_db:
    name: "{{ etherpad_database_name }}"
    collation: utf8mb4_general_ci
    state: present
- name: Grant permissions to user
  mysql_user:
    name: "{{ etherpad_database_user }}"
    state: present
    priv: "{{ etherpad_database_name }}.*:ALL"
    password: "{{ etherpad_database_password }}"