Back on brandybuck as mountdoom, install MariaDB

sudo apt install -y mariadb-server

Run secure install script

sudo /usr/bin/mariadb-secure-installation

Answer a serie of questions

• Leave password blank
• Switch to unix_socket authentication n
• Change the root password n
• Remove anonymous users y
• Disallow root login remotely y
• Remove test database and access to it y
• Reload privilege tables now y

Connect

sudo mariadb

Create the Pixelfed database:

CREATE DATABASE pixelfeddb;

Create a dedicated user:

CREATE USER 'pixelfed'@'localhost' IDENTIFIED BY 'mariadb-password';

GRANT ALL PRIVILEGES ON pixelfeddb.* TO 'pixelfed'@'localhost';

FLUSH PRIVILEGES;

quit