mysql 5.7 docker-composed

connect.sh

mysql -h localhost -u USER -P 3306 -p --protocol=TCP

db_Dockerfile

FROM mysql/mysql-server:5.7.38

# place
ADD init-users.sql /docker-entrypoint-initdb.d/
ADD init-db.sql /docker-entrypoint-initdb.d/

db_init-users.sql

CREATE USER IF NOT EXISTS 'USER'@'%' IDENTIFIED BY 'password';
ALTER USER 'USER'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'USER'@'%' WITH GRANT OPTION;

docker-compose.yaml

version: '3.5'
services:
    database:
        restart: unless-stopped
        build: db
        ports:
            - 3306:3306/tcp
        environment:
            MYSQL_ROOT_PASSWORD: rootpassword
            MYSQL_DATABASE: DBNAME
            MYSQL_USER: USER
            MYSQL_PASSWORD: password
        volumes:
            - db-vol:/PATH_TO_VOL/db-vol:rw
volumes:
    db-vol: