wiki

[root@rh73 ~]| cat create-mysql.sh 

#!/bin/bash

# create random password
PASS="$(openssl rand -base64 12)"

mysql -uroot << EOF
CREATE DATABASE IF NOT EXISTS $1;
CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';
GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
FLUSH PRIVILEGES;
EOF

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