Related

Product App Platform: Run Node apps without managing servers Product
Now Available: Managed MySQL Databases Product
EJS Reference Error Question Question
ERROR: Two Factor Code: R857T Question Question

Question

Can't connect to MySQL using Node.JS

Posted March 15, 2016 17.1k views
MySQLNode.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

Add a comment
killjoys
By:
killjoys

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
ryanpq June 23, 2016

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.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help