[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_bin
[client]
default-character-set = utf8mb4

ROOT_PASS=root
DB_NAME=test
DB_USER=user
DB_PASS=password
DB_PORT=3306

CREATE DATABASE IF NOT EXISTS test;

USE test;

CREATE TABLE sample (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, name TEXT);

INSERT INTO sample (name) VALUES ('name1'), ('name2'), ('name3');

version: '3.8'
services:
  mysql-server:
    image: mysql:8.0
    ports:
      - ${DB_PORT}:3306
    command: --default-authentication-plugin=mysql_native_password
    volumes:
      - ./my.cnf:/etc/mysql/conf.d/my.cnf
      - ./init:/docker-entrypoint-initdb.d
    env_file:
      - .env
    environment:
      MYSQL_ROOT_PASSWORD: ${ROOT_PASS}
      MYSQL_DATABASE: ${DB_NAME}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASS}
    restart: always
    tty: true

Creating network "mysql-on-docker_default" with the default driver
Creating mysql-on-docker_mysql-server_1 ... done

             Name                           Command               State                 Ports
-----------------------------------------------------------------------------------------------------------
mysql-on-docker_mysql-server_1   docker-entrypoint.sh --def ...   Up      0.0.0.0:3306->3306/tcp, 33060/tcp

Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.31 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT * FROM sample;
+----+-------+
| id | name  |
+----+-------+
|  1 | name1 |
|  2 | name2 |
|  3 | name3 |
+----+-------+
3 rows in set (0.00 sec)

mysql> \q
Bye

Stopping mysql-on-docker_mysql-server_1 ... done
Removing mysql-on-docker_mysql-server_1 ... done
Removing network mysql-on-docker_default

.
├── .env
├── docker-compose.yml
├── init
│   └── 00-init.sql
└── my.cnf

1 directory, 4 files