#!/bin/bash

# mpw=`cat /usr/local/sbin/mpw`

# vraag om user als niet op commandline
if test "$1" = ""; then
  read -p "Username: " user
else
  user="$1"
  echo "Username: $user"
fi
if test "$user" = ""; then
  echo geen user.
  exit
fi

read -p "Database: " -ei $user db
echo    "Hostname: localhost"
read -p "Password: " -ei `pwgen -s 10` password

# test of database al bestaat
output=`mysql -uroot <<EOD
show databases like "$db";
EOD`
if test "$output" != ""; then
  echo "Deze database bestaat al"
  echo "Als dat correct is druk dan op return, of druk om te stoppen op ctrl-c"
  read
fi

# test of mysql-user al bestaat
output=`mysql <<EOD
use mysql;
select User from user where user="$user";
EOD`

if test "$output" != ""; then
  echo "Deze mysql-user bestaat al."
  echo "Als dat correct is druk dan op return, of druk om te stoppen op ctrl-c"
  read
fi

mysql <<EOD
create database $db;
grant all on $db.* to $user@localhost identified by '$password';
flush privileges;
EOD

# log
logfile=/root/ng.log
date >> $logfile
echo "Database: $db" >> $logfile
echo "Username: $user" >> $logfile
echo "Paswoord: $password" >> $logfile

# paswoord tijdelijk opslaan voor Wordpress
touch /tmp/$user
chmod 600 /tmp/$user
echo $password > /tmp/$user
echo "rm /tmp/$user >/dev/null 2>&1" | at now + 5 minutes >/dev/null 2>&1

echo "Done."
echo