added mysql service account

springframeworkguru · springframeworkguru · commit 91f4d3d68198 · 2016-05-27T18:41:50.000-04:00
diff --git a/src/main/SQL/mysql-service-account.sql b/src/main/SQL/mysql-service-account.sql
@@ -0,0 +1,6 @@
+CREATE USER 'springframework'@'localhost' IDENTIFIED BY 'guru';
+
+GRANT SELECT ON springguru.* to 'springframework'@'localhost';
+GRANT INSERT ON springguru.* to 'springframework'@'localhost';
+GRANT DELETE ON springguru.* to 'springframework'@'localhost';
+GRANT UPDATE ON springguru.* to 'springframework'@'localhost';
diff --git a/src/main/resources/application-qa.properties b/src/main/resources/application-qa.properties
@@ -1,7 +1,7 @@
 guru.springframework.profile.message=This is my QA Profile
 
 spring.datasource.url=jdbc:mysql://localhost:3306/springguru
-spring.datasource.username=root
-spring.datasource.password=
+spring.datasource.username=springframework
+spring.datasource.password=guru
 
 spring.jpa.hibernate.ddl-auto=update
