====== MariaDB ======
Weil ich es mir schlicht nicht merken kann :-D

  CREATE DATABASE [DBNAME] CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  CREATE USER '[USERNAME]'@'[SOURCEIP]' IDENTIFIED BY '[PASSWOR]';
  grant all privileges on [DBENAME].* to '[USERNAME]'@'[SOURCEIP]' ;
  flush privileges;