Create MySQL database with random user

create_db.sh

#!/bin/bash

pass=`openssl rand -hex 12`
db=$1

if [ -z $1 ]; then
  db=`openssl rand -hex 12`
fi

user=$db

echo "/*"
echo "db   : $db";
echo "user : $user";
echo "pass : $pass";
echo "*/";

echo "\n";

echo "START TRANSACTION;";
echo "CREATE DATABASE \`$db\`;";
echo "CREATE USER '$user'@'%' IDENTIFIED BY '$pass';";
echo "GRANT ALL PRIVILEGES ON \`$db\`.* TO '$user'@'%';";
echo "COMMIT;"