MySQL 접속

1
2
3

sudo mysql 
-------------------
mysql -u root -p

새로운 유저 생성

1

mysql> CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';

사용자 계정 삭제

Ubuntu 패키지 정보 업데이트

1
2

sudo apt update
sudo apt upgrade

MySQL 설치

1

sudo apt install -y mysql-server

MySQL 기본 세팅

Select Instance(Amazon Linux2 AMI) With t2.micro

Configure Security group - Add types [SSH(22), HTTP(80)]

Instance Spec

Survey (EC2, Auto Scaling, S3, RDS)

What is Amazon EC2?

Abbreviation for Amazon Elastic Compute Cloud, it provides scalable computing capacity in the Amazon Web Services (AWS) cloud.

With Amazon EC2, you can,

• Build as many virtual servers as you want,
• Manage security, network configuration, storage
• •Reduces the need to predict server traffic more

What is Amazon Auto Scaling?