Mysql Lab

docker-compose.yml

services:
  mysql:
    image: mysql:8.0
    container_name: mysql
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: rootpass
      MYSQL_DATABASE: mydb
      MYSQL_USER: user
      MYSQL_PASSWORD: userpass
    ports:
      - "3306:3306"
    volumes:
      - mysql_data:/var/lib/mysql

  phpmyadmin:
    image: phpmyadmin:latest
    container_name: phpmyadmin
    restart: unless-stopped
    environment:
      PMA_HOST: mysql
      PMA_PORT: 3306
      PMA_USER: root
      PMA_PASSWORD: rootpass
    ports:
      - "8080:80"
    depends_on:
      - mysql

volumes:
  mysql_data:

Makefile

#!/usr/bin/make

.PHONY = all clean

BASH := $(shell which bash)

up: 
	bash -c 'docker-compose -p mysql-server -f docker-compose.yml up -d --build'

down:
	bash -c 'docker-compose -p mysql-server -f docker-compose.yml down'

run-once.sh

# create network
docker network create mysql-net

# run mysql
docker run -d \
  --name mysql \
  --network mysql-net \
  -e MYSQL_ROOT_PASSWORD=rootpass \
  -e MYSQL_DATABASE=mydb \
  -e MYSQL_USER=user \
  -e MYSQL_PASSWORD=userpass \
  -p 3306:3306 \
  -v mysql_data:/var/lib/mysql \
  mysql:8.0


# run phpmyadmin
docker run -d \
  --name phpmyadmin \
  --network mysql-net \
  -e PMA_HOST=mysql \
  -e PMA_PORT=3306 \
  -p 8080:80 \
  phpmyadmin:latest