GDJ 24/06/11 (AWS, MariaDB 연결, Java 설치)

AWS - MariaDB 연결 & JAVA 설치 순서

AWS ubuntu(linux 명령어)

> sudo apt-get update

> sudo apt-get upgrade -y

> sudo apt-get install apt-transport-https curl

> sudo mkdir -p /etc/apt/keyrings

> sudo curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'

> sudo vi /etc/apt/sources.list.d/mariadb.sources

> i 입력 > INSERT모드

>
X-Repolib-Name: MariaDB
Types: deb
URIs: https://tw1.mirror.blendbyte.net/mariadb/repo/11.3/ubuntu
Suites: focal
Components: main main/debug
Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp

> ESC 버튼 > :wq!

> sudo apt-get update

> sudo apt-get install mariadb-server

> sudo mysql -uroot -p (패스워드 물어보면 그냥 엔터)

> use mysql;

> set password=password('java1234'); > exit;

> mysql -uroot -p > 비밀번호입력(입력안보임)

> use myql;

> grant all privileges on *.* to 'root'@'localhost' identified by '비밀번호';

> grant all privileges on *.* to 'root'@'%' identified by '비밀번호';

> flush privileges; > exit

> sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf

> i (INSERT mode) > bind-address = 0.0.0.0 으로 변경 > esc > :wq!

> sudo service mysql restart

> AWS 우분투 > 관리 > 네트워킹 > 방화벽 규칙추가
> MySQL/Aurora 3306 선택 후 생성

> hidieSQL IP 변경, 비밀번호 입력

> java 설치
> sudo apt update

> sudo apt upgrade -y

> sudo apt install openjdk-17-jdk -y

> java -version (자바 버전확인)