#!/usr/bin/env bash

CUSTOMER_DB_USER=user
CUSTOMER_DB_NAME=name
CUSTOMER_DB_PASSWORD=password

cat <<QUERY_INPUT
CREATE DATABASE IF NOT EXISTS $CUSTOMER_DB_NAME;
CREATE USER $CUSTOMER_DB_USER@'%' IDENTIFIED BY $CUSTOMER_DB_PASSWORD;
GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'localhost';
GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'%';
FLUSH PRIVILEGES;
QUERY_INPUT