#!/bin/bash
if [ "$#" != "3" ]; then
   echo -e "You should set 3 parametres: \n\$1 = Mysql Username (can be existing one, but password will change), \n\$2 = database name, \n\$3 = password for mysql user.\nFor example, you can run this:\ncreatedatabase.sh user database password" 1>&2
   exit 1
fi
dbuser=$1
dbname=$2
dbpassword="$3"
dbdir="/var/lib/mysql/"
echo "database directory to check: $dbdir"
if [ -e $dbdir/$dbname ]; then
    echo -e "Database exist\n\nI am dying now\nChoose another name for your database.\n\n" && exit
fi
echo "Creating database..."
mysql -e "create database \`$dbname\`; grant all on \`$dbname\`.* to '$dbuser'@'localhost'; set password for '$dbuser'@'localhost' = password('$dbpassword');"
if [ $? != 0 ];
then
    echo -e "\n\nSorry, it seems some errors ocured. Check STDOUT to see."
else
    echo -e "DB $dbname created.\nMysql user, which can access this database:\n     $dbuser\nPassword for $dbuser in mysql:\n     $dbpassword"
fi