#!/bin/bash

# Usage: sudo /usr/local/bin/new_db $NAME

NAME=$1
PASSWORD=`< /dev/urandom tr -dc A-Za-z0-9 | head -c16; echo`

/opt/rh/rh-mysql57/root/usr/bin/mysql -e "CREATE DATABASE $NAME;"
/opt/rh/rh-mysql57/root/usr/bin/mysql -e "GRANT ALL PRIVILEGES ON $NAME.* TO '$NAME'@'localhost' IDENTIFIED BY '$PASSWORD';"

echo "" >> /home/admin/user_details.txt
echo "Database Name: $NAME"
echo "Database Name: $NAME" >> /home/admin/user_details.txt
echo "Database Username: $NAME"
echo "Database Username: $NAME" >> /home/admin/user_details.txt
echo "Database Password: $PASSWORD"
echo "Database Password: $PASSWORD" >> /home/admin/user_details.txt