# Add deb repo: script
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
# Update apt cache
sudo apt update
# Installing MDB
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common -y
 
# Secure mariadb
sudo mysql_secure_installation

CREATE DATABASE db1 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci' COMMENT 'demodb';
# OR
CREATE DATABASE IF NOT EXISTS db1;
# OR
CREATE OR REPLACE DATABASE db1;

DROP DATABASE db1;
# OR
DROP DATABASE IF EXISTS db1;

ALTER DATABASE db1 CHARACTER SET='utf8'  COLLATE='utf8_bin';