PromptHub
Back to Errors
Database Error ECONNREFUSED Intermediate 409 views

ECONNREFUSED

The network connection was refused by the target server.

Explanation

ECONNREFUSED is a system error indicating that the connection attempt was actively refused by the server at the target address and port. This means the server is reachable but not accepting connections on the specified port. In Node.js, this commonly happens when trying to connect to a database, Redis, API server, or any network service that isn't running or isn't listening on the expected port. It's different from ETIMEDOUT which means no response at all.

Common Causes

  • Target service not running
  • Wrong host or port configuration
  • Firewall blocking connection
  • Docker container networking issue
  • Service bound to wrong interface

Solution

Verify the target service is running and listening on the expected port. Check the host and port configuration. Ensure no firewall is blocking the connection. For Docker, verify container networking and port mapping. Use telnet or nc to test connectivity: telnet host port. Check if the service is bound to the correct interface (0.0.0.0 vs 127.0.0.1). For cloud environments, verify security groups allow inbound traffic.

Code Example 

// Node.js connection to database
const mysql = require('mysql2');
const connection = mysql.createConnection({
    host: 'localhost',
    port: 3306,
    user: 'root',
    password: 'secret'
});

connection.connect((err) => {
    if (err) {
        if (err.code === 'ECONNREFUSED') {
            console.error('MySQL is not running!');
        }
        return;
    }
    console.log('Connected!');
});

// Redis connection
const Redis = require('ioredis');
const redis = new Redis({
    host: '127.0.0.1',
    port: 6379,
    retryStrategy: (times) => Math.min(times * 50, 2000)
});

// Test connectivity
const net = require('net');
const socket = net.createConnection(3306, 'localhost');
socket.on('connect', () => {
    console.log('Port 3306 is open');
    socket.end();
});
socket.on('error', (err) => {
    console.error('Connection refused:', err.message);
});

Error Information

Language

javascript

Framework

nodejs

Difficulty

Intermediate

Views

409

Related Errors

Database

Table Doesn't Exist

The SQL query references a table that doesn't exist in the database.
Database

Too Many Connections

The database server has reached its maximum connection limit.
Database

Lock Wait Timeout Exceeded

A database query waited too long for a lock held by another transaction.
Database

Database Connection Refused or Timeout

The database server is not reachable or took too long to respond.
All tools