0
# rds full 권한

aws configure


# 선수 조건
default vpc에 rds를 생성하는 예제이다.
default vpc가 있어야 한다.



1
# YourPassword123!  ??    good1001!


aws rds create-db-instance \
    --db-instance-identifier my-rds-instance \
    --db-instance-class db.t3.micro \
    --engine mysql \
    --master-username admin \
    --master-user-password "YourPassword123!" \
    --allocated-storage 20 \
    --db-name mydatabase \
    --publicly-accessible



aws rds create-db-instance \
    --db-instance-identifier my-rds-instance \
    --db-instance-class db.t3.micro \
    --engine mysql \
    --master-username admin \
    --master-user-password "good1001!" \
    --allocated-storage 20 \
    --db-name mydatabase \
    --publicly-accessible


2

#  DBInstances[0].Endpoint.Address  확인
# rds 생성후  (5분 소요) Endpoint.Address 복사해두자   
# console에서 rds생성 확인 

aws rds describe-db-instances \
    --db-instance-identifier my-rds-instance \
    --query "DBInstances[0].Endpoint.Address" \
    --output text


aws rds describe-db-instances \
    --db-instance-identifier my-rds-instance \
    --query "my-rds-instance.c1gecq0s0wvn.ap-northeast-2.rds.amazonaws.com" \
    --output text



3
 
# 보안 그룹 허용
aurora/rds 


4

mysql -h <엔드포인트-주소> -P 3306 -u admin -p


mysql -h my-rds-instance.c1gecq0s0wvn.ap-northeast-2.rds.amazonaws.com -P 3306 -u admin -p



5

USE mydatabase;


6

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);




7


INSERT INTO users (name, email) VALUES ('홍길동', 'hong@example.com');
INSERT INTO users (name, email) VALUES ('김철수', 'kim@example.com');



8

SELECT * FROM users;


9
exit