mysql-create.sh

#!/bin/sh

USER="root";
PASS="pass";

# Run a mysql command as root
mysqlcommand() {
  echo "$@";
	mysql -u"$USER" -p"$PASS" -e "$@";
}

# Create the database
mysqlcommand "CREATE DATABASE IF NOT EXISTS \`$1\` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;";

# Create the user
mysqlcommand "CREATE USER '$1'@localhost IDENTIFIED BY '$1';";

# Grant permissions
mysqlcommand "GRANT ALL PRIVILEGES ON \`$1\`.* TO '$1'@localhost WITH GRANT OPTION;";