Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ERROR=0
- MYSQL_ROOT_USER=$1
- MYSQL_ROOT_PASSWORD=$2
- DB_TO_CREATE=$3
- USER_TO_CREATE=$4
- PASSWORD_FOR_USER=$5
- if [ -z "$MYSQL_ROOT_USER" ]
- then
- echo "Enter MYSQL_ROOT_USER";
- ERROR=1
- fi
- if [ -z "$MYSQL_ROOT_PASSWORD" ]
- then
- echo "Enter MYSQL_ROOT_PASSWORD";
- ERROR=1
- fi
- if [ -z "$DB_TO_CREATE" ]
- then
- echo "Enter DB_TO_CREATE";
- ERROR=1
- fi
- if [ -z "$USER_TO_CREATE" ]
- then
- echo "Enter USER_TO_CREATE";
- ERROR=1
- fi
- if [ -z "$PASSWORD_FOR_USER" ]
- then
- echo "Enter PASSWORD_FOR_USER";
- ERROR=1
- fi
- if [ "$ERROR" -eq "1" ]
- then
- echo "Please correct above error"
- exit 1;
- fi
- MYSQL_SCRIPT="""
- CREATE DATABASE ${DB_TO_CREATE};
- CREATE USER ${USER_TO_CREATE}@localhost IDENTIFIED BY '${PASSWORD_FOR_USER}';
- GRANT ALL PRIVILEGES ON ${DB_TO_CREATE}.* TO '${USER_TO_CREATE}'@'localhost';
- FLUSH PRIVILEGES;
- """
- echo "Running Script: \n $MYSQL_SCRIPT"
- `mysql -u$MYSQL_ROOT_USER -p$MYSQL_ROOT_PASSWORD -e "$MYSQL_SCRIPT" `
Add Comment
Please, Sign In to add comment