#!   /bin/bash

MYSQL_ROOT="root"
MYSQL_ROOT_PW="dbrootpass"
JOOMLA_DB="joomladb"
JOOMLA_DB_USER="joomlauser"
JOOMLA_DB_PW="dbjoomlauserpass"

# Build the Database with the information provided above
mysql -u $MYSQL_ROOT --password="$MYSQL_ROOT_PW" << fin
create database $JOOMLA_DB default character set utf8 collate utf8_general_ci;
create user '$JOMMLA_DB_USER'@'localhost' identified by '$JOOMLA_DB_PW';
grant all on $JOOMLA_DB.* to '$JOOMLA_DB_USER'@'localhost';
fin