如何在docker中执行sql文件？

Question

我有 lamp 项目并尝试在 Docker compose 中运行它。该应用程序正在运行，但与 mysql 没有连接。原因：sql文件没有执行，数据库没有创建。当我进入容器并手动运行 sql 文件时，一切正常。

 version: '3.7'
services:
  
  db:
    build:
      context: ./database
      dockerfile: Dockerfile    
    container_name: data36
    environment:      
      - MYSQL_ROOT_PASSWORD=password123      
      - MYSQL_DATABASE=php_mysql_crud
    volumes:
      - ./database/script.sql:/docker-entrypoint-initdb.d/script.sql
      -  mysqlvol:/var/lib/mysql
    restart: always
    ports:
      - 3306:3306
    networks:
      - app

  php:
    container_name: php8
    build:
      context: .
      dockerfile: Dockerfile
    volumes:
      - .:/var/www/html/
    ports:
      - 8000:80
    networks:
      - app
    depends_on:
      - db
      
volumes:
 database:
 mysqlvol:

networks:
  app:
    driver: bridge
    


Dockerfile:


FROM mysql:5.7.17

ENV MYSQL_ROOT_PASSWORD password123

COPY script.sql /docker-entrypoint-initdb.d/

RUN chown -R mysql:mysql /docker-entrypoint-initdb.d/

EXPOSE 3306

CMD ["mysqld", "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]

如何在容器中执行script.sql？？？