#!/bin/bash

HOST=localhost
PORT=3306
USER=root
PASS=mysecretrootpassword

DB_NAME=$1
DB_USER=$2
DB_PASS=$3


if [ $# == 3 ]; then
    echo Creating MySQL database $DB_NAME on $HOST with user $DB_USER / $DB_PASS.

    SQL="CREATE DATABASE $DB_NAME; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON $DB_NAME.* TO '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';"


    echo $SQL > /tmp/qry.txt

    mysql -u$USER -p$PASS < /tmp/qry.txt

    rm /tmp/qry.txt
else
    echo "This command needs 3 arguments."
    echo "createdb.sh <db_name> <db_user> <db pass>";
fi