Setting up containers for my NestJS + TypeORM + MySQL environment using Docker Compose on a Windows 10 host is proving to be challenging as I keep encountering an ECONNREFUSED error:
connect ECONNREFUSED 127.0.0.1:3306 +2ms
backend_1 | Error: connect ECONNREFUSED 127.0.0.1:3306
backend_1 | at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1145:16)
backend_1 | --------------------
...
A Dockerfile has been created to configure the NestJS API container:
FROM node:12-alpine
WORKDIR /usr/src/app
COPY package.json .
RUN npm install
EXPOSE 3000
CMD /wait-for-it.sh db:3306 -- npm start
COPY . .
This is referenced in the docker-compose.yml:
version: "3.8"
networks:
app-tier:
driver: bridge
services:
db:
image: mysql
command: --default-authentication-plugin=mysql_native_password
restart: always
expose:
- "3306"
ports:
- "3306:3306"
networks:
- app-tier
environment:
MYSQL_DATABASE: school
...
backend:
depends_on:
- db
build: .
ports:
- "3000:3000"
networks:
- app-tier
TypeORM configuration matching the Docker Compose file:
export const DB_CONFIG: TypeOrmModuleOptions = {
type: 'mysql',
host: 'db',
port: 3306,
username: 'dbuser',
password: 'dbuser',
database: 'school',
entities: [],
synchronize: true,
};
Despite trying various solutions like changing output ports and adding explicit network settings, the issue persists. Any suggestions?
Edit 1
Added MYSQL_ROOT_HOST and wait-for-it.sh as recommended, but still no luck.