MÉMO MARIADB — BTS SIO SISR
===========================
Préparation
  hostname -f                     nom complet de la machine
  ip -br a ; ip route             réseau
  sudo apt update && sudo apt full-upgrade -y

Installation
  sudo apt install -y mariadb-server
  sudo systemctl status mariadb
  sudo ss -tlnp | grep 3306

Sécurisation
  sudo mariadb-secure-installation
  /etc/mysql/mariadb.conf.d/50-server.cnf  ->  bind-address = 127.0.0.1

Base + utilisateur applicatif (moindre privilège)
  CREATE DATABASE app CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  CREATE USER 'app'@'localhost' IDENTIFIED BY '<mot de passe généré>';
  GRANT SELECT, INSERT, UPDATE, DELETE ON app.* TO 'app'@'localhost';
  SHOW GRANTS FOR 'app'@'localhost';

Générer un mot de passe :  openssl rand -base64 24