에러헤결

AWS RDS를 DataGrip 연결 시 발생하는 문제 (DBMS: MariaDB (no ver.)Case sensitivity: plain=mixed, delimited=exactSocket fail to connect to host:address=(host=umc-rds-test.cgrxpidbha93.ap-northeast-2.rds.amazonaws.com)(port=3306)(type=primary). C..

곰돌이볼 2023. 6. 10. 11:53

에러 코드

DBMS: MariaDB (no ver.)Case sensitivity: plain=mixed, delimited=exactSocket fail to connect to host:address=(host=umc-rds-test.cgrxpidbha93.ap-northeast-2.rds.amazonaws.com)(port=3306)(type=primary). Connection timed out: no further information.

 

에러 상황

  • AWS RDS를 DataGrip 연결 시 아래와 같은 오류 문구 표시
DBMS: MariaDB (no ver.)Case sensitivity: plain=mixed, delimited=exactSocket fail to connect to host:address=(host=umc-rds-test.cgrxpidbha93.ap-northeast-2.rds.amazonaws.com)(port=3306)(type=primary). Connection timed out: no further information.

 

해결 방법

  • AWS의 RDS에 인바운드 규칙 추가하기
    • Anywhere-IPv4 과 Anywhere-IPv6 설정 추가하기

 

  • 인바운드 규칙 추가 후 DataGrip과 AWS RDS 연동 성공

 

참고 사이트

저작자표시 (새창열림)

'에러헤결' 카테고리의 다른 글

MySQL 연동 오류 (Re-enter new password: ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Plaase consider using ALTER USER instea..  (0) 2023.06.10
java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'  (0) 2023.05.19
Table 'Carrot_Market.users' doesn't exist  (1) 2023.05.19
Resolved [org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot construct instance of `com.example.umcspring.user.dto.UserDto$Post` (although at least one Creator exists): cannot deserialize from Object value (no d..  (0) 2023.05.19
CMake Error at cmake/ssl.cmake:64 (MESSAGE) :cannot find appropriate system libraries for with_ssl=system  (0) 2023.05.16

'에러헤결'의 다른글

  • 현재글AWS RDS를 DataGrip 연결 시 발생하는 문제 (DBMS: MariaDB (no ver.)Case sensitivity: plain=mixed, delimited=exactSocket fail to connect to host:address=(host=umc-rds-test.cgrxpidbha93.ap-northeast-2.rds.amazonaws.com)(port=3306)(type=primary). C..

관련글

댓글

티스토리툴바