#!/bin/bash

dpkg --status mariadb-server >/dev/null 2>/dev/null
if [ $? -ne 0 ];
then
    apt update
    apt install -y mariadb-server openssl
    ROOTPASSWORD=$(openssl rand -base64 12)
    echo "!! Your root password is: $ROOTPASSWORD"
    mysql --user=root <<_EOF_
UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root';
ALTER USER 'root'@'localhost' IDENTIFIED BY '$ROOTPASSWORD';
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
DROP DATABASE IF EXISTS test;
DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
FLUSH PRIVILEGES;
_EOF_
else
    echo "ERROR: mariadb-server is already installed. Exiting..." >&2
    exit 1
fi