Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sh cat_test.sh
- CREATE DATABASE IF NOT EXISTS name;
- CREATE USER user@'%' IDENTIFIED BY password;
- GRANT ALL ON name.* TO user@'localhost';
- GRANT ALL ON name.* TO user@'%';
- FLUSH PRIVILEGES;
- ==========================================================
- #!/usr/bin/env bash
- CUSTOMER_DB_USER=user
- CUSTOMER_DB_NAME=name
- CUSTOMER_DB_PASSWORD=password
- cat <<QUERY_INPUT
- CREATE DATABASE IF NOT EXISTS $CUSTOMER_DB_NAME;
- CREATE USER $CUSTOMER_DB_USER@'%' IDENTIFIED BY $CUSTOMER_DB_PASSWORD;
- GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'localhost';
- GRANT ALL ON $CUSTOMER_DB_NAME.* TO $CUSTOMER_DB_USER@'%';
- FLUSH PRIVILEGES;
- QUERY_INPUT
Add Comment
Please, Sign In to add comment