#!/bin/bash

#
# script to add db,user,pass, perms
_db="$1"
_user="$2"
_pass="$3"
_dbperms="$4"

# make sure we get 3 arguments, if not, exit
(( $# < 3 )) && { echo "Usage: $0 'DBName' 'DBUSER' 'DBPASSORD' ['DB_PERMS']" >&2; exit 1; }

# default to ALL
_dbperms=${_dbperms:-"ALL"}

mysql -u root -e "CREATE DATABASE ${_db};"