MariaDB

Weil ich es mir schlicht nicht merken kann

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;