setup

#! /bin/bash

newUser='USERNAME'
newDbPassword='PASSWORD'

#########DO NOT EDIT BELOW THIS LINE################

newDb='fieldday'
host=localhost
#host='%'
 
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}" | sudo /usr/bin/mysql -u root -p