do-db.sh

#!/bin/bash
source ~/.digitalocean_password 
MAX_ARGS=3
BAD_ARG=65
SQL=`which mysql`
  
CMD1="CREATE DATABASE IF NOT EXISTS $1;"
CMD2="GRANT USAGE ON *.* TO $2@localhost IDENTIFIED BY '$3';"
CMD3="GRANT ALL PRIVILEGES ON $1.* TO $2@localhost;"
CMD4="FLUSH PRIVILEGES;"
SQLCMD="${CMD1}${CMD2}${CMD3}${CMD4}"
  
if [ $# -ne $MAX_ARGS ]
then
  echo "Usage: $0 dbname dbuser dbpass"
  exit $BAD_ARG
fi
  
$SQL -uroot -p$root_mysql_pass -e "$SQLCMD"