#!/usr/bin/env bash

set -e

PASS=`pwgen -s 40 1`

mysql -uroot <<MYSQL_COMM

CREATE DATABASE $1;

CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';

GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';

FLUSH PRIVILEGES;

MYSQL_COMM

echo "MySQL user created."

echo "Username:   $1"

echo "Password:   $PASS"