#!/usr/bin/env bash

database=$1
username=$2
password=$3

if [ ! "$password" ]; then
        echo "usage: DB_HOST= DB_USER= DB_PASSWORD= command <database> <username> <password>"
        exit 1
fi

mysql -h"$DB_HOST" -u"$DB_USER" -p"$DB_PASSWORD" <<EOF
create database if not exists $database;
grant all on $database.* TO '$username'@'%' identified by '$password';
flush privileges;
EOF