1 mariadb
Markus Bergholz edited this page 1 month ago

create database

create database thisdb  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

create user

CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword';

grant all privileges to one database

GRANT ALL PRIVILEGES ON thisdb.* TO 'myuser'@'%';