Create mysql user & db and provide permissions to user for the created db

mysql_user.sh

#!/bin/bash

ERROR=0
MYSQL_ROOT_USER=$1
MYSQL_ROOT_PASSWORD=$2
DB_TO_CREATE=$3
USER_TO_CREATE=$4
PASSWORD_FOR_USER=$5

if [ -z "$MYSQL_ROOT_USER" ]
then
    echo "Enter MYSQL_ROOT_USER";
    ERROR=1
fi

if [ -z "$MYSQL_ROOT_PASSWORD" ]
then
    echo "Enter MYSQL_ROOT_PASSWORD";
    ERROR=1
fi

if [ -z "$DB_TO_CREATE" ]
then
    echo "Enter DB_TO_CREATE";
    ERROR=1
fi

if [ -z "$USER_TO_CREATE" ]
then
    echo "Enter USER_TO_CREATE";
    ERROR=1
fi

if [ -z "$PASSWORD_FOR_USER" ]
then
    echo "Enter PASSWORD_FOR_USER";
    ERROR=1
fi

if [ "$ERROR" -eq "1" ]
then
    echo "Please correct above error"
    exit 1;
fi


MYSQL_SCRIPT="""
CREATE DATABASE ${DB_TO_CREATE};
CREATE USER ${USER_TO_CREATE}@localhost IDENTIFIED BY '${PASSWORD_FOR_USER}';
GRANT ALL PRIVILEGES ON ${DB_TO_CREATE}.* TO '${USER_TO_CREATE}'@'localhost';
FLUSH PRIVILEGES;
"""

echo "Running Script: \n $MYSQL_SCRIPT"

`mysql -u$MYSQL_ROOT_USER -p$MYSQL_ROOT_PASSWORD -e "$MYSQL_SCRIPT" `