#! /bin/bash
service mysql start; COMMAND=“CREATE USER ‘$DATABASE_USERNAME’@‘localhost’ IDENTIFIED BY ‘$DATABASE_PASSWORD’;”; COMMAND=“$COMMAND CREATE USER ‘$DATABASE_USERNAME’@‘%’ IDENTIFIED BY ‘$DATABASE_PASSWORD’;”;
COMMAND=“$COMMAND GRANT ALL ON $DATABASE_NAME.* to ‘$DATABASE_USERNAME’@‘localhost’;”; COMMAND=“$COMMAND GRANT ALL ON $DATABASE_NAME.* to ‘$DATABASE_USERNAME’@‘%’;”; COMMAND=“$COMMAND CREATE DATABASE $DATABASE_NAME;”;
mysql -uroot -e “$COMMAND”;