#!/bin/bash

PASS='xxxxxxxx'

mysql -u root -p$PASS <<MYSQL_SCRIPT
CREATE DATABASE $1;
CREATE USER '$1'@'localhost' IDENTIFIED BY '$1';
GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
FLUSH PRIVILEGES;
MYSQL_SCRIPT

echo "MySQL user created."
echo "Database: $1"
echo "Username: $1"
echo "Password: $1"