dockercompose：无法将应用程序服务连接到 mysql 数据库，收到错误：用户‘root’@‘localhost’访问被拒绝(使用密码：YES)

我正在通过 docker 组合启动两个 docker 集装箱.

docker-compose.yml个文件的内容:

version: "3.7"

services:
  app:
    image:  my-app:latest
    ports:  
      - 8000:8000
    working_dir: /usr/app/MyApp
    environment: 
      MYSQL_ROOT_PASSWORD: myawesomepassword
      MYSQL_DATABASE: myawesomedb
      MYSQL_USER: root
      MYSQL_PASSWORD: myawesomepassword
  mysql:
    image:  mysql:5.6
    volumes:
      - db-data:/var/lib/mysql 
    environment: 
      MYSQL_ROOT_PASSWORD: myawesomepassword
      MYSQL_DATABASE: myawesomedb
volumes:
  db-data: {}

该应用程序连接到数据库的方式如下:

import mysql from 'mysql2/promise.js';

var config = {
    app: {
        host: 'http://localhost',
        port: '8000'
    },
    database: {
        host: 'host.docker.internal',
        port: 3306,
        database: process.env['MYSQL_DATABASE'],
        user: process.env['MYSQL_USER'],
        password: process.env['MYSQL_PASSWORD']
    }
}

const {host, port, user, password, database } = config.database;

// Error occurs here
const connection = await mysql.createConnection({ host, port, user, password });

当应用程序服务try 连接到MySQL时，我收到以下错误:

Error: Access denied for user 'root'@'localhost' (using password: YES)个

欢迎任何建议.提前感谢你了