mysql docker 설치 방법 (명령어)

docker create --name mysql8 -e MYSQL_ROOT_PASSWORD=root -p 13306:3306 mysql:8.0.27

 

docker start mysql8

 

데이터베이스, DB 사용자, 권한 설정

create database jpabegin CHARACTER SET utf8mb4;

 

CREATE USER 'jpauser'@'localhost' IDENTIFIED BY 'jpapass';

CREATE USER 'jpauser'@'%' IDENTIFIED BY 'jpapass';

 

GRANT ALL PRIVILEGES ON jpabegin.* TO 'jpauser'@'localhost';

GRANT ALL PRIVILEGES ON jpabegin.* TO 'jpauser'@'%';

 

 

create table jpabegin.user(

  email varchar(50) not null primary key,

  name varchar(50),

  create_date datetime,

) engine innodb character set utf8mb4;