MySQL: User Setup Script

db-user-setup.sh

#!/bin/bash

# Create db - if it doesnt exist, and setup user ready to
# read and write
#
# Usage: db-user-setup.sh <database> <user> <password>


EXPECTED_ARGS=3
E_BADARGS=65
MYSQL=`which mysql`

Q1="CREATE DATABASE IF NOT EXISTS $1;"
Q2="GRANT USAGE ON *.* TO $2@localhost IDENTIFIED BY '$3';"
Q3="GRANT ALL PRIVILEGES ON $1.* TO $2@localhost;"
Q4="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}${Q4}"
  
if [ $# -ne $EXPECTED_ARGS ]
then
  echo "Usage: $0 database user pass"
  exit $E_BADARGS
fi
  
$MYSQL -uroot -p -e "$SQL"