Create new MySQL database

addmysqldb.sh

#!/bin/sh

DB="$1"

if [ -z "$DB" ]; then
	echo "Usage: addmysqldb DB"
	exit 0
fi

RESULT=$(echo "CREATE DATABASE \`$DB\` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;" |mysql5 mysql 2>&1)

if [ $? > 0 ]; then
  echo "$RESULT"
  exit 1
fi

echo "Created database '$DB' with UTF-8 character set."