create-mysql-users

#!/bin/bash

  PATH='/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin'
  DbNaam="${1}"
  usert="${2}"
  Wachtwoord="${3}"
  SCRIPT_PATH="${0}"

 # Check if 2 args given
  if [ "$#" -ne 3 ]
  then
      echo "error: please provide 3 arguments"
      echo "Usage: ${SCRIPT_PATH} dbnaam username wachtwoord"
      exit 0
  fi

mysql -Be "create database ${DbNaam}"
mysql -Be "GRANT ALL ON ${DbNaam}.* TO ${usert}@localhost IDENTIFIED BY '${Wachtwoord}';"
mysql -Be "flush privileges;"