Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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 19.5k 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
EJS Reference Error Question Question
ERROR: Two Factor Code: R857T Question Question

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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help