Linux(2)
-
20240409 Linux SQL SpringBoots
# abbs의 SQL문 SET SESSION FOREIGN_KEY_CHECKS=0; /* Drop Tables */ DROP TABLE IF EXISTS anniversary; DROP TABLE IF EXISTS likes; DROP TABLE IF EXISTS reply; DROP TABLE IF EXISTS board; DROP TABLE IF EXISTS schedule; DROP TABLE IF EXISTS users; /* Create Tables */ CREATE TABLE anniversary ( aid int NOT NULL AUTO_INCREMENT, uid varchar(12) NOT NULL, aname varchar(20) NOT NULL, adate char(8) NOT NULL..
2024.04.09 -
20240409 Amazon Linux 설정
- 사용자 등록 및 로그인 설정 # sudo useradd userId # sudo passwd userId 9글자 이상 # sudo vi /etc/ssh/sshd_config /PasswordAuthentication no/ PasswordAuthentication no ==> PasswordAuthentication yes :wq # sudo service sshd restart - JDK 설치 # sudo yum install java-17-amazon-corretto # sudo vi /etc/profile # export JAVA_HOME=/usr/lib/jvm/java-17-amazon-corretto.x86_64 - MySQL 설치 # wget https://repo.mysql.c..
2024.04.09