sudo yum install mariadb-server
sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service
mysql_secure_installation
접속
mysql -u root -p
password:
포트번호 확인
SHOW GLOBAL VARIABLES LIKE 'PORT';
DB 생성 및 권한 부여
CREATE DATABASE db이름 default CHARACTER SET UTF8;
GRANT ALL PRIVILEGES ON db이름.* TO 유저이름@localhost IDENTIFIED BY '비밀번호';
# db 삭제
DROP DATABASE 데이터베이스 이름
gralde 설정
dependencies {
implementation 'mysql:mysql-connector-java'
implementation 'org.springframework.boot:spring-boot-starter-jdbc'
}
yml 설정
spring:
datasource:
url: jdbc:mysql://localhost:3306/testdb?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&serverTimezone=Asia/Seoul
username: 유저이름
password: 비밀번호
jpa:
hibernate:
ddl-auto: create # DB 테이블 새로 생성
Amazon Linux 2 버전 설치방법
sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
sudo amazon-linux-extras install epel -y
sudo yum -y install mysql-community-server
sudo systemctl enable --now mysqld
systemctl status mysqld
sudo grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p
ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '변경할 비밀번호';
FLUSH PRIVILEGES;