Create database and setup credentials

create-db-credentials.sh

#!/usr/bin/env bash

bin="mysql"
#bin="/Applications/MySQLWorkbench.app/Contents/MacOS/mysql"

database=$1
username=$2
password=$3

if [ ! "$password" ]; then
        echo "usage: DB_HOST= DB_USER= DB_PASSWORD= command <database> <username> <password>"
        exit 1
fi

"$bin" -h"$DB_HOST" -u"$DB_USER" -p"$DB_PASSWORD" <<EOF
create database if not exists $database;
grant all on $database.* TO '$username'@'%' identified by '$password';
flush privileges;
EOF

See created user accounts:

select concat(quote(user),'@',quote(host)) UserAccount from mysql.user;