mariadb create database and grant privileges to database code example

Example: create user mariadb

CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';