CREATE DATABASE `testdb` 
	default charset=utf8 collate utf8_general_ci;

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
	default charset=utf8 collate utf8_general_ci;

docker run -d `
    --network todo-app --network-alias mysql `
    -v todo-mysql-data:/var/lib/mysql `
    -e MYSQL_ROOT_PASSWORD=secret `
    -e MYSQL_DATABASE=todos `
    mysql:5.7 `
    --character-set-server=utf8 `
    --collation-server=utf8_general_ci

version: "3.8"

services:
  mysql:
    image: mysql:5.7
    volumes:
      - todo-mysql-data:/var/lib/mysql
    environment: 
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_DATABASE: todos
    command:
      - --character-set-server=utf8 
      - --collation-server=utf8_general_ci


volumes:
  todo-mysql-data: