Guest User

Untitled

a guest
Aug 5th, 2016
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. sh cat_test.sh
  2. CREATE DATABASE IF NOT EXISTS name;
  3. CREATE USER user@'%' IDENTIFIED BY password;
  4. GRANT ALL ON name.* TO user@'localhost';
  5. GRANT ALL ON name.* TO user@'%';
  6. FLUSH PRIVILEGES;
  7.  
  8. ==========================================================
  9.  
  10. #!/usr/bin/env bash
  11.  
  12. CUSTOMER_DB_USER=user
  13. CUSTOMER_DB_NAME=name
  14. CUSTOMER_DB_PASSWORD=password
  15.  
  16. cat <<QUERY_INPUT
  17. CREATE DATABASE IF NOT EXISTS $CUSTOMER_DB_NAME;
  18. CREATE USER $CUSTOMER_DB_USER@'%' IDENTIFIED BY $CUSTOMER_DB_PASSWORD;
  19. GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'localhost';
  20. GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'%';
  21. FLUSH PRIVILEGES;
  22. QUERY_INPUT
Add Comment
Please, Sign In to add comment