For MariaDB 10.1.26

Check server running : bin/mysqladmin version

Stop server : mysqladmin shutdown

Initial user : root

Initial password : none

Typical tasks:

Create user : create user using UNIX name so the -u parameter is not needed to enter mysql

CREATE USER ‘user’ IDENTIFIED BY ‘password’

CREATE ROLE ‘role’

GRANT role to user

SET DEFAULT ROLE role

GRANT ALL PRIVILEGES ON db.* to user

CREATE DATABASE db

SHOW DATABASES