#!/bin/bash
set -e
apt update && apt install apache2 mariadb-server php php-mysql unzip -y
mysql -e "CREATE DATABASE IF NOT EXISTS cmseg_cloud CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql -e "CREATE USER IF NOT EXISTS 'cmseg_user'@'localhost' IDENTIFIED BY 'TROQUE_ESSA_SENHA';"
mysql -e "GRANT ALL PRIVILEGES ON cmseg_cloud.* TO 'cmseg_user'@'localhost'; FLUSH PRIVILEGES;"
mysql cmseg_cloud < /var/www/html/cmseg-cloud/sql/install.sql
systemctl restart apache2