전체 구조
1. 인스턴스 생성 : MySQL 설치
apt-get update
apt-get install mysql-server
systemctl start mysql
netstat -anlp | grep :3306
systemctl enable mysql
mysql -u root -p
mysql -V
혹은
mysql -version
ALTER USER 'root'@'localhost' IDENTIFIED BY 'qwer';
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('qwer');
CREATE DATABASE minji;
CREATE USER 'minji-s'@'localhost' IDENTIFIED BY 'qwer1234';
FLUSH PRIVILEGES;
SELECT User, Host, authentication_string FROM mysql.user;
+------------------+-----------+-------------------------------------------+
| User | Host | authentication_string |
+------------------+-----------+-------------------------------------------+
| root | localhost | |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| minji | localhost | |
+------------------+-----------+-------------------------------------------+
GRANT ALL PRIVILEGES ON minji.* to minji@localhost;
FLUSH PRIVILEGES;
CREATE USER 'minji'@'%' IDENTIFIED BY 'qwer';
GRANT ALL PRIVILEGES ON * . * TO 'minji'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
CREATE USER 'minji'@'192.168.1.100' IDENTIFIED BY 'qwer';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.100' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT User, Host, authentication_string FROM mysql.user;
+------------------+-----------+-------------------------------------------+
| User | Host | authentication_string |
+------------------+-----------+-------------------------------------------+
| root | localhost | |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| minji | % | |
+------------------+-----------+-------------------------------------------+
vi /etc/mysql/mysql.conf.d/mysqld.cnf
systemctl restart mysql
ufw disable
ufw allow mysql
apt-get install mysql-client
mysql -u minji -p -h 100.101.10.240
2. 인스턴스 생성 : Tomcat 설치
wget https://mirror.navercorp.com/apache/tomcat/tomcat-9/v9.0.46/bin/apache-tomcat-9.0.46.tar.gz
tar -zvxf apache-tomcat-9.0.8.tar.gz
apache-tomcat-9.0.8/bin/
ubuntu@root:~/test/downloads$ cd apache-tomcat-9.0.8/
ubuntu@root:~/test/downloads/apache-tomcat-9.0.8$ cd bin
ubuntu@root:~/test/downloads/apache-tomcat-9.0.8/bin$ ./startup.sh
Using CATALINA_BASE: /home/ubuntu/test/downloads/apache-tomcat-9.0.8
Using CATALINA_HOME: /home/ubuntu/test/downloads/apache-tomcat-9.0.8
Using CATALINA_TMPDIR: /home/ubuntu/test/downloads/apache-tomcat-9.0.8/temp
Using JRE_HOME: /home/ubuntu/java
Using CLASSPATH: /home/ubuntu/test/downloads/apache-tomcat-9.0.8/bin/bootstrap.jar:/home/ubuntu/test/downloads/apache-tomcat-9.0.8/bin/tomcat-juli.jar
Tomcat started.
apache-tomcat-9.0.8/bin/
scp -i "Downloads/key (1).pem" /Users/minz/Downloads/web/build/libs/web.war ubuntu@13.209.9.46:~/
./catalina.sh run
# 실행 후 문제
3. 이미지 만들기
vi /etc/systemd/system/tomcat.service
useradd tomcat
chown -R tomcat:tomcat /usr/local/tomcat
systemctl enable tomcat
systemctl restart tomcat
SELECT default_character_set_name, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA
WHERE schema_name = "mydb";
![[AWS] AMI 이미지 만들기: Ubuntu에 Tomcat·MySQL 설치하고 스프링부트 배포](/posts/aws-ami-spring-boot-deploy-tomcat-mysql/images/image_1.jpg)