Why am I getting the error "connect ECONNREFUSED 127.0.0.1:3306" when seeding with Sequelize?

The error "connect ECONNREFUSED 127.0.0.1:3306" when seeding with Sequelize indicates that your application is unable to establish a connection to the MySQL server at the specified address (127.0.0.1) and port (3306). This is a common issue, and several reasons could be causing it.

Here are some potential causes and troubleshooting steps:

1. MySQL Server Not Running:

- Ensure that your MySQL server is running. This might seem obvious, but it’s the most frequent cause. Check the server status using your operating system's service manager or the MySQL command-line tool.

2. Incorrect Host or Port:

- Double-check the host and port configuration in your Sequelize configuration file (usually config.json or in your sequelize.js file). Make sure it matches your MySQL server's configuration.

- Example config.json:

{
  "development": {
    "username": "your_username",
    "password": "your_password",
    "database": "your_database",
    "host": "127.0.0.1",
    "port": 3306,
    "dialect": "mysql"
  }
}

3. Firewall Issues:

- A firewall might be blocking the connection. Ensure that your firewall allows connections to port 3306 on your MySQL server.

4. Incorrect Credentials:

- Verify that the username and password in your Sequelize configuration are correct and that the user has the necessary privileges to access the database.

5. MySQL Server Binding:

- By default, MySQL might be configured to only accept local connections. Check the bind-address setting in your MySQL configuration file (typically my.cnf or my.ini). If it's set to 127.0.0.1, it will only accept local connections. To allow connections from other machines, you can comment out or change this line to 0.0.0.0 (but be cautious about security implications). After making changes, restart the MySQL server.

6. Sequelize Version and Dependencies:

- Ensure that you have the correct version of sequelize and mysql2 (or the appropriate MySQL driver) installed. Update them if necessary:

npm install sequelize mysql2 --save

7. Database Not Created:

- Make sure the database you are trying to connect to exists. You can create it using the MySQL command-line client or a GUI tool like MySQL Workbench.

8. Insufficient Privileges:

- The MySQL user might not have the necessary privileges to connect to the database or perform seeding operations. Grant the appropriate privileges to the user.

Here's an example of how to grant privileges:

GRANT ALL PRIVILEGES ON your_database. TO 'your_username'@'localhost';
FLUSH PRIVILEGES;

By checking these points, you should be able to resolve the "connect ECONNREFUSED" error and successfully seed your database with Sequelize. If the problem persists, carefully review your configuration files and error logs for more specific clues.

Learn more about this