• 보안그룹 설정

PostgreSQL

# postgrsql
sudo yum install -y postgresql15
psql <데이터베이스 이름> -h <엔드포인트> -U <사용자 이름>

# 예:
psql -U postgres -h skills-database.cluster-crlbc4spvdhr.ap-northeast-2.rds.amazonaws.com

create database dev;
\\c dev;

create schema dev;
CREATE TABLE dev.users (
idx SERIAL PRIMARY KEY,
username VARCHAR(255) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL
);

MySQL

sudo dnf install -y mariadb105

mysql -u wscc -h wscc-database.cluster-cfkga6eu1jon.ap-northeast-2.rds.amazonaws.com -p

create database dev;
use dev;

CREATE TABLE dev.users (
idx SERIAL PRIMARY KEY,
username VARCHAR(255) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL
);