Basic MariaDB Setup

#install apache and db
apt install apache2 apache2-utils mariadb-server mariadb-client

#setup root password and permissions
mysql_secure_installation

#install phpmyadmin
apt install phpmyadmin

#add user
mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';

#shell notes
https://pastebin.com/Ny03YMYX