mysql5.7 delimiter_Docker撰写：MySQL语法错误“DELIMITER”在第1行

我有问题,我希望Docker Compose在设置MySQL后直接导入我的Database.sql文件.但它总是抛出我的错误：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DELIMITER |’ at line 1

但不知何故,当我通过浏览器中的phpMyAdmin导入它时,它的工作原理非常好.

这是我的docker-compose.yml：

version: "3.2"

services:

php:

build: './php/'

networks:

- backend

volumes:

- ./www/:/var/www/html/

apache:

build: './apache/'

depends_on:

- php

- mysql

networks:

- frontend

- backend

ports:

- "8081:80"

volumes:

- ./www/:/var/www/html/

mysql:

image: mysql:5.7

volumes:

- ./mysql:/tmp/database

command: mysqld --max_allowed_packet=32505856 --user=root --init-file="/tmp/database/schema.sql"

networks:

- backend

environment:

- MYSQL_ROOT_PASSWORD=root

phpmyadmin:

image: phpmyadmin/phpmyadmin

links:

- mysql

ports:

- '8082:80'

environment:

MYSQL_USERNAME: root

MYSQL_ROOT_PASSWORD: root

PMA_HOST: mysql

networks:

- backend

networks:

frontend:

backend:

这是我的.sql文件的一个示例片段,它被执行：

-- phpMyAdmin SQL Dump

-- version 4.8.2

-- https://www.phpmyadmin.net/

--

-- Host: mysql

-- Generation Time: Aug 20, 2018 at 08:30 AM

-- Server version: 5.7.23

-- PHP Version: 7.2.6

DELIMITER $$

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

START TRANSACTION;

SET time_zone = "+00:00";

--

-- Database: `database`

--

CREATE DATABASE IF NOT EXISTS `databasetest` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

USE `databasetest`;

--

-- Procedures

--

DROP PROCEDURE IF EXISTS `sp_filestatus_get`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_filestatus_get` (IN `filename_name` VARCHAR(500), IN `kampagne_name` VARCHAR(100), IN `outlet_name` VARCHAR(100)) NO SQL

... Some more stuff

END;

我错过了配置中的一些内容吗？或者为什么它不能与compose一起工作但直接在phpMyAdmin中有效？