# [Docker] Docker Compose mySQL 실행하기

🌞 2024.12.12 Thu

1. 기존 cli 실행

• 복잡함. 

🧿🧿🧿 << command line interface>> 🧿🧿🧿

$ docker run -e MYSQL_ROOT_PASSWORD=pwd1234 -p 3306:3306 -v /Users/**username**/Desktop/DevData/docker-mysql/mysql_data:/var/lib/mysql -d mysql

2. mySQL compose file 생성 및 실행

📝📝📝 << compose.yml file >> 📝📝📝

services:
  my-db:
    image: mysql
    environment: 
      MYSQL_ROOT_PASSWORD: pwd1234
    volumes:
      - ./mysql_data:/var/lib/mysql
    ports: 
      - 3306:3306

• environment: =$ -e MYSQL_ROOT_PASSWORD=qwer123
• volumn : =$ -v {호스트 경로}: /var/lib/mysql
  🧿🧿🧿 << command line interface>> 🧿🧿🧿

  docker compose up 
  docker compose ps
  docker ps
  docker exec -it [container] bash
  $ mysql -u root -p
  $ show databases;
  $ use [tablename]
  $ show tables;

• dbeaver , mysql workbench 등으로 3306 port 들어가서 확인