Can't get connected to mysql db using sequelize and docker

General Discussions
1

I am trying to connect to Mysql database using docker-compose in node.js

ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 192.168.32.2:3306

here is how my docker-compose.yml looks like

version: '3.9'

services:
  db:
    image: 'mysql'
    ports:
      - '3306:3306'
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: 12345678
      MYSQL_DATABASE: sweeft
      MYSQL_USER: sweeft_user
      MYSQL_PASSWORD: 12345678

  server:
    build: .
    ports:
      - '3000:3000'
    depends_on:
      - db
    environment:
      DB_HOST: db
      DB_USER: sweeft_user
      DB_PASSWORD: 12345678
      DB_NAME: sweeft

I am trying to connect like this

import Sequelize from 'sequelize';

const sequelize = new Sequelize('sweeft', 'sweeft_user', 12345678, {
  host: 'db',
  dialect: 'mysql',
});

export default sequelize;

error I am getting in the Docker Desktop

Screenshot 2023-09-29 at 20.19.31
Screenshot 2023-09-29 at 20.19.312244×1196 383 KB

2

When you start multiple services in Docker compose, they are usually attached to a default Docker network. Your server app should connect within the Docker network to db, you do not need to expose ports on the db service.

But the mentioned IP 192.x.x.x seems strange, Docker networks usually have a different IP range. Have you tried setting up a dedicated Docker network and attaching both services? See simple Traefik example.

3

No, I have not tried I’ll try it, one thing to note is that on every new build, I get new IP

172.18.0.2:3306 for example

4

Now that looks like a Docker network IP :slightly_smiling_face: