Running MySQL in Docker Container – Techtips @ hofsvang.no

2024-10-05
bjorn
Docker / MySQL

This is the easiest way you can run MySQL in a Docker Container

You have to have a Linux installed with Docker CE (27.3.1) installed (https://www.hofsvang.no/?p=165)
Make an .env file in directory ~/docker/mysql

MYSQL_DB=testdb
MYSQL_USER=MyUserName
MYSQL_PASSWORD=MyPassword
MYSQL_ROOT_PASSWORD=MyRootPassword
MYSQL_PORT=3306
Make a docker-compose.yaml file like this for persistent data in directory ~/docker/mysql

services:
  db:
    image: mysql:9.0.1
    restart: always
    environment:
      MYSQL_DATABASE: ${MYSQL_DB}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
    ports:
      - '${MYSQL_PORT}:3306'
    volumes:
      - data:/var/lib/mysql
      - conf:/etc/mysql
volumes:
  data:
  conf: