#! /bin/bash

dbName="$1"
dbUser="php_mariadb"
host='%'

echo "dbName: ${dbName}"
echo "dbUser: ${dbUser}"

commands="CREATE DATABASE \`${dbName}\`;GRANT USAGE ON *.* TO '${dbUser}'@'${host}' IDENTIFIED BY '123456';GRANT ALL privileges ON \`${dbName}\`.* TO '${dbUser}'@'${host}';FLUSH PRIVILEGES;"
# commands="SHOW DATABASES;"
# echo "${commands}" | /usr/bin/mariadb -u php_mariadb -pphp.maria%db
echo "${commands}" | /usr/bin/mariadb -u root -p



# newUser='testuser'
# newDbPassword='testpwd'
# newDb='testdb'
# host=localhost
# host='%'

# echo "hallo ${newDb}"
 
# commands="CREATE DATABASE \`${newDb}\`;CREATE USER '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT USAGE ON *.* TO '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT ALL privileges ON \`${newDb}\`.*
# TO '${newUser}'@'${host}';FLUSH PRIVILEGES;"

# echo "${commands}" | /usr/bin/mariadb -u root -p