Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM mysql.user WHERE User = '${web_app_sql_user}';
- #!/bin/bash
- echo -e "Creating a SQL user and database for the webapp"
- read -s -p "enter SQL root user password: " password
- cat <<- EOF | mysql -v -uroot -p$password
- DROP DATABASE IF EXISTS `${web_app_database}`;
- CREATE DATABASE `${web_app_database}` CHARACTER SET utf8 COLLATE utf8_general_ci;
- -- Deal with possibility user already exists!
- DELETE FROM mysql.user WHERE User = '${web_app_sql_user}';
- -- drop user ${web_app_sql_user}@localhost;
- FLUSH PRIVILEGES;
- CREATE USER '${web_app_sql_user}'@localhost IDENTIFIED BY '${web_app_sql_user_password}';
- -- CREATE USER '${web_app_sql_user}'@localhost IDENTIFIED BY '${web_app_sql_user_password}';
- GRANT ALL ON ${web_app_database}.* TO '${web_app_sql_user}'@'localhost';
- GRANT USAGE ON * . * TO '${web_app_sql_user}'@'localhost' IDENTIFIED BY '${web_app_sql_user_password}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
- GRANT ALL PRIVILEGES ON `${web_app_database}` . * TO '${web_app_sql_user}'@'localhost';
- FLUSH PRIVILEGES;
- EOF
- --------------
- DROP DATABASE IF EXISTS `web_app_database`
- --------------
- --------------
- CREATE DATABASE `web_app_database` CHARACTER SET utf8 COLLATE utf8_general_ci
- --------------
- --------------
- DELETE FROM mysql.user WHERE User = 'web_app_user'
- --------------
- --------------
- FLUSH PRIVILEGES
- --------------
- --------------
- CREATE USER 'web_app_user'@localhost IDENTIFIED BY ''
- --------------
- ERROR 1396 (HY000) at line 17: Operation CREATE USER failed for 'web_app_user'@'localhost'
- GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY '...' WITH ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement