Node.js connect to MySQL Docker container ECONNREFUSED

by

This:

mysql:
    image: mysql:5.7
    environment:
    ...
    ports:
      - "3307:3306"

Means that Docker will map the 3307 port of the host to the 3306 port of the container. So you can access from Sequel to localhost:3307.

However, it does not mean that the container is listenting to 3307; the container is in fact still listening to 3306. When others containers tries to access the mysql DNS, it gets translated to the internal container IP, therefore you must connect to 3306.

So your node config should look like:

const config = {
    host: 'mysql',
    database: 'mydb',
    port: '3306',
    user: 'mysql',
    password: '1234',
    connectionLimit: 10
}

And this in your docker-compose.yml:

command: ["./wait-for-it.sh", "mysql:3306"]

Note: wait-for-it.sh script comes from: https://github.com/vishnubob/wait-for-it

More Related Contents:

  1. Docker-compose check if mysql connection is ready
  2. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  3. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  4. Connect to Docker MySQL container from localhost?
  5. How to connect locally hosted MySQL database with the docker container
  6. connecting to a docker-compose mysql container denies access but docker running same image does not
  7. django cannot connect mysql in docker-compose
  8. How can i write in NodeJS with MongoDB the following MySQL Select?
  9. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  10. MySQL with Node.js
  11. node-mysql multiple statements in one query
  12. nodejs mysql Error: Connection lost The server closed the connection
  13. How can I initialize a MySQL database with schema in a Docker container?
  14. Connect to mysql in a docker container from the host
  15. Node.js can’t authenticate to MySQL 8.0
  16. How to access a RowDataPacket object
  17. MongoDB on with Docker “failed to connect to server [localhost:27017] on first connect “
  18. Retrieve last inserted id with Mysql
  19. connect ECONNREFUSED – node js , sql
  20. Commit data in a mysql container
  21. How to make join queries using Sequelize on Node.js
  22. NodeJS MySQL Dump
  23. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  24. Access to mysql container from other container
  25. Error in MySQL library for Node.js
  26. Which ORM should I use for Node.js and MySQL? [closed]
  27. find number of rows in returned mysql result (nodejs)
  28. How to initialize mysql container when created on Kubernetes?
  29. MySQL giving “read ECONNRESET” error after idle time on node.js server
  30. MySQL scripts in docker-entrypoint-initdb are not executed

Leave a Comment