codingNoob12
commented
5 months ago 문제 해결했습니다...
아래의 스크립트를 실행해서 codingNoob12@localhost를 생성해주어도 스프링 부트가 codingNoob12@{IP주소} 형태로 엑세스하려고 하더라구요. 아마도 스프링 부트 내부적으로 localhost를 IP로 변환해 인식하고 있는 것 같습니다
스프링 부트가 엑세스하는 codingNoob12@{IP주소} 형태로 사용자 생성, 권한부여 하니 제대로 커넥션 잡히고 로그도 정상적으로 나옵니다.
06:47:47.402 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils -- Could not detect default configuration classes for test class [com.fastcampus.projectboard.FastCampusProjectBoardApplicationTests]: FastCampusProjectBoardApplicationTests does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
06:47:47.468 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper -- Found @SpringBootConfiguration com.fastcampus.projectboard.FastCampusProjectBoardApplication for test class com.fastcampus.projectboard.FastCampusProjectBoardApplicationTests
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.4)
2024-04-11T06:47:47.714+09:00 INFO 57693 --- [ main] p.FastCampusProjectBoardApplicationTests : Starting FastCampusProjectBoardApplicationTests using Java 17.0.10 with PID 57693 (started by seoilhyeon in /Users/seoilhyeon/Documents/study/fastcampus/spring 초격차/fastcampus-project-board)
2024-04-11T06:47:47.714+09:00 DEBUG 57693 --- [ main] p.FastCampusProjectBoardApplicationTests : Running with Spring Boot v3.2.4, Spring v6.1.5
2024-04-11T06:47:47.715+09:00 INFO 57693 --- [ main] p.FastCampusProjectBoardApplicationTests : No active profile set, falling back to 1 default profile: "default"
2024-04-11T06:47:48.241+09:00 INFO 57693 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-04-11T06:47:48.252+09:00 INFO 57693 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 7 ms. Found 0 JPA repository interfaces.
2024-04-11T06:47:48.578+09:00 INFO 57693 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2024-04-11T06:47:48.609+09:00 INFO 57693 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.4.4.Final
2024-04-11T06:47:48.630+09:00 INFO 57693 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2024-04-11T06:47:48.773+09:00 INFO 57693 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2024-04-11T06:47:48.790+09:00 INFO 57693 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2024-04-11T06:47:48.981+09:00 INFO 57693 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@341ccfd1
2024-04-11T06:47:48.982+09:00 INFO 57693 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2024-04-11T06:47:49.019+09:00 WARN 57693 --- [ main] org.hibernate.orm.deprecation : HHH90000025: MySQLDialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2024-04-11T06:47:49.217+09:00 INFO 57693 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2024-04-11T06:47:49.219+09:00 INFO 57693 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2024-04-11T06:47:49.347+09:00 WARN 57693 --- [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2024-04-11T06:47:49.416+09:00 DEBUG 57693 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : 2 mappings in 'requestMappingHandlerMapping'
2024-04-11T06:47:49.526+09:00 DEBUG 57693 --- [ main] o.s.w.s.handler.SimpleUrlHandlerMapping : Patterns [/webjars/**, /**] in 'resourceHandlerMapping'
2024-04-11T06:47:49.559+09:00 DEBUG 57693 --- [ main] s.w.s.m.m.a.RequestMappingHandlerAdapter : ControllerAdvice beans: 0 @ModelAttribute, 0 @InitBinder, 1 RequestBodyAdvice, 1 ResponseBodyAdvice
2024-04-11T06:47:49.587+09:00 DEBUG 57693 --- [ main] .m.m.a.ExceptionHandlerExceptionResolver : ControllerAdvice beans: 0 @ExceptionHandler, 1 ResponseBodyAdvice
2024-04-11T06:47:49.933+09:00 INFO 57693 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 13 endpoint(s) beneath base path '/actuator'
2024-04-11T06:47:49.990+09:00 INFO 57693 --- [ main] p.FastCampusProjectBoardApplicationTests : Started FastCampusProjectBoardApplicationTests in 2.44 seconds (process running for 3.043)
OpenJDK 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended
2024-04-11T06:47:50.432+09:00 INFO 57693 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2024-04-11T06:47:50.434+09:00 INFO 57693 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2024-04-11T06:47:50.443+09:00 INFO 57693 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
Process finished with exit code 0
안녕하세요 강사님, 학습을 하던 중 해당 DB Connection Error로 트러블 슈팅을 하게 되었습니다. 현재 MySQL 8.0.36 버전, Spring Boot 3.2.4버전을 이용중입니다. 터미널에서는 잘 로그인되고 권한도 제대로 부여되었는데, 스프링 부트 애플리케이션을 실행하면 아래와 같은 에러 메시지가 출력됩니다.
아래에서는 'id'@'IP주소'형태로 실제로 나오는데, 보안상 '{ip주소}'로 고친점 이해부탁드립니다.
위의 에러가 발생하는데 어떻게 해결해야 될까요? 설정 파일은 다음과 같습니다.
application.yaml