export DATABASE_NAME="hda_production"
export DATABASE_USER="amahihda"
export DATABASE_PASSWORD="AmahiHDARulez"
export DATABASE_MAIN_USER="root"
export DATABASE_MAIN_PASSWORD="hda"
mysqladmin -u ${DATABASE_MAIN_USER} -p#{DATABASE_MAIN_PASSWORD} -f drop #{DATABASE_NAME}
mysqladmin -u ${DATABASE_MAIN_USER} -p#{DATABASE_MAIN_PASSWORD} create #{DATABASE_NAME}
echo "GRANT ALL PRIVILEGES ON *.* TO '${DATABASE_USER}'@'localhost' IDENTIFIED BY '#{DATABASE_PASSWORD}' WITH GRANT OPTION;" | mysql -u #{DATABASE_MAIN_USER} -p#{DATABASE_MAIN_PASSWORD}