Createing MariaDB (MySQL) Database

To enter MariaDB.

sudo mariadb

Create database. Replace database name with your desired database name (spaces and hyphens are invalid character).

CREATE DATABASE database name;

Grant database user privileges to database. This will create your database user and grant it privileges to the database. Replace database name, username, and password with the database name you created in the last step and your desired username and password (apostophes are a part of the command; spaces and hyphens are invalid character).

GRANT ALL PRIVILEGES ON database name.* TO 'username'@'localhost' IDENTIFIED BY 'password';

Exit MariaDB.

EXIT;