How to fix problem with World-writable config file '/etc/mysql/my.cnf' is ignored?

Question

Windows

Hello! There is a docker compose and there is a database section, it looks like this:

db:
    platform: linux/x86_64
    image: mysql:latest
    ports:
      - '${DB_PORT}:3306'
    environment:
      MYSQL_ROOT_PASSWORD: '${MYSQL_ROOT_PASSWORD}'
      MYSQL_DATABASE: '${MYSQL_DATABASE}'
      MYSQL_USER: '${MYSQL_USER}'
      MYSQL_PASSWORD: '${MYSQL_PASSWORD}'
    volumes:
      - './docker/mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d'
      - './docker/mysql/db_data:/var/lib/mysql'
      - './docker/mysql/my.cnf:/etc/mysql/my.cnf'
      - './docker/logs/mysql:/var/log/mysql'

When running, the logs have this error, and only on windows
mysqld: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored.

And macos works great!

googled, they are asked to change the access rights, which they have not already set, it does not help.
The entire project is located on the C drive.

Answer 1

Write permissions allow everyone to change the config.
And you need to give such rights so that only root can make changes to the config

Answer 2

You can try like this
- './docker/mysql/my.cnf:/etc/mysql/my.cnf:ro'