Create a MySQL Database

create_mysql_db.sh

usage() {
    echo "Usage: $0 <DB_NAME> <DB_USER> <DB_PASSWORD>"
    exit
}

DB_NAME=$1
DB_USER=$2
DB_PASSWORD=$3

[ -z "${DB_NAME}" -o -z "${DB_USER}" -o -z "${DB_PASSWORD}" ] && usage

mysql -u root -p << EOF
drop database if exists ${DB_NAME};
create database ${DB_NAME} character set 'utf8';
use ${DB_NAME};
grant all on ${DB_NAME}.* to ${DB_USER}@localhost identified by '${DB_PASSWORD}';
flush privileges;
EOF