How to fix Error: connect ECONNREFUSED 127.0.0.1:3306 in Node.js

Node.jsBEGINNERHIGH

Occurs when Node.js cannot establish a TCP connection to MySQL server because the server is not running, not listening on the specified port, or blocked by firewall.

What this error means

Placeholder meaning for ECONNREFUSED: Connection refused to MySQL. This error needs detailed documentation.

Typical symptoms

Symptom 1
Symptom 2
Symptom 3

Common causes

Cause 1
Cause 2
Cause 3

How to fix "Error: connect ECONNREFUSED 127.0.0.1:3306"

1Fix step 1

Placeholder fix instructions

Advanced notes

Placeholder advanced notes.

Related errors

Error: EMFILE: too many open files, watch
EMFILE: fs.watch() limit exceeded
HIGH
Error: Middleware next() called multiple times (next() invoked twice)
Express middleware next() called multiple times
HIGH
Error: Worker failed to initialize (worker startup error)
Worker failed to initialize in Node.js
HIGH

Official resources & further reading

📚Node.js Official Documentation
📖
node-mysql2 GitHub - MySQL connection and error handling(Official Docs)
📖
node-mysql2 documentation - connection configuration(Official Docs)
🐙
node-mysql2 - Can connect from mysql cli but not from node-mysql2(GitHub)
📝
w3tutorials - Checking MySQL Exceptions in Node.js