AWS RDS DB 인스턴스 연결 오류 : ERROR 2003 (HY000): Can't connect to MySQL server on

hyeongirlife·2022년 7월 15일
0

TIL

목록 보기
89/90
post-thumbnail

발생한 에러

➜  ~ mysql -h hyeongeol-login.crgqxmr1poym.ap-northeast-2.rds.amazonaws.com -u admin -p
Enter password: 
ERROR 2003 (HY000): Can't connect to MySQL server on 'hyeongeol-login.crgqxmr1poym.ap-northeast-2.rds.amazonaws.com:3306' (110)

해결방법

해당 RDS의 보안그룹에 들어가 모든 소스가 접근할 수 있도록 소스유형을 IPv4, IPv6 모두 가능하도록 설정

결과

➜  ~ mysql -h hyeongeol-login.crgqxmr1poym.ap-northeast-2.rds.amazonaws.com -u admin -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 8.0.28 Source distribution

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

profile
머릿속에 있는 내용을 정리하기

0개의 댓글