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

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

1. Cause 1
2. Cause 2
3. Cause 3

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

Advanced notes

Frequently asked questions

What does "ECONNREFUSED" mean?

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

How do I fix "ECONNREFUSED"?

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 causes "ECONNREFUSED"?

Cause 1 Cause 2 Cause 3

Is the "ECONNREFUSED" error serious?

Yes. This is a high-severity error that usually blocks work until it is fixed, but the steps above resolve it.

Related errors

• ER_CON_COUNT_ERROR: Too many connections

  ER_CON_COUNT_ERROR: Too many connections

  HIGH

• ER_ACCESS_DENIED_ERROR: Access denied for user 'username'@'host' (using password: YES/NO)

  ER_ACCESS_DENIED_ERROR: Access denied for user

  HIGH

• Error: Failed to load native module './build/Release/addon.node'

  Failed to load native module 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