Guest User

Untitled

a guest
Jan 5th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. ERROR=0
  4. MYSQL_ROOT_USER=$1
  5. MYSQL_ROOT_PASSWORD=$2
  6. DB_TO_CREATE=$3
  7. USER_TO_CREATE=$4
  8. PASSWORD_FOR_USER=$5
  9.  
  10. if [ -z "$MYSQL_ROOT_USER" ]
  11. then
  12. echo "Enter MYSQL_ROOT_USER";
  13. ERROR=1
  14. fi
  15.  
  16. if [ -z "$MYSQL_ROOT_PASSWORD" ]
  17. then
  18. echo "Enter MYSQL_ROOT_PASSWORD";
  19. ERROR=1
  20. fi
  21.  
  22. if [ -z "$DB_TO_CREATE" ]
  23. then
  24. echo "Enter DB_TO_CREATE";
  25. ERROR=1
  26. fi
  27.  
  28. if [ -z "$USER_TO_CREATE" ]
  29. then
  30. echo "Enter USER_TO_CREATE";
  31. ERROR=1
  32. fi
  33.  
  34. if [ -z "$PASSWORD_FOR_USER" ]
  35. then
  36. echo "Enter PASSWORD_FOR_USER";
  37. ERROR=1
  38. fi
  39.  
  40. if [ "$ERROR" -eq "1" ]
  41. then
  42. echo "Please correct above error"
  43. exit 1;
  44. fi
  45.  
  46.  
  47. MYSQL_SCRIPT="""
  48. CREATE DATABASE ${DB_TO_CREATE};
  49. CREATE USER ${USER_TO_CREATE}@localhost IDENTIFIED BY '${PASSWORD_FOR_USER}';
  50. GRANT ALL PRIVILEGES ON ${DB_TO_CREATE}.* TO '${USER_TO_CREATE}'@'localhost';
  51. FLUSH PRIVILEGES;
  52. """
  53.  
  54. echo "Running Script: \n $MYSQL_SCRIPT"
  55.  
  56. `mysql -u$MYSQL_ROOT_USER -p$MYSQL_ROOT_PASSWORD -e "$MYSQL_SCRIPT" `
Add Comment
Please, Sign In to add comment