Question

Can't connect to MySQL using Node.JS

Posted March 15, 2016 13.7k views
MySQL Node.js

First of all, I never use Linux and Digital Ocean

I already created a droplet of MySQL and change my password after login for the first time

and try to connect using Node.JS

but an error occured

[Error : connect ECONNREFUSED]
code : 'ECONNREFUSED'
errno : 'ECONNREFUSED',
syscall : 'connect',
fatal : true

Thank you very much

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer

By default MySQL only listens for local connections so another droplet will not be able to reach the service. Before you can reach your MySQL service from another computer you will have to adjust your /etc/mysql/my.cnf file so that bind-address is either commented out, set to 0.0.0.0 to listen on all interfaces or is your droplet’s public or private IP.

Submit an Answer