node.js mysql error: ECONNREFUSED

Question

Why can't I connect to the mysql server?

On the same server an Apache/PHP server is running and it connects without problems!?

var mysql_link = {
    host : 'localhost',
    port : 3308,
    database: 'nodetest',
    user : 'root',
    password : 'xxx'
};

var connection = mysql.createConnection(mysql_link);

connection.connect(function(err){
    console.log(err);
    if(err != null){
        response.write('Error connecting to mysql:' + err+'\n');
    }
});

connection.end();

error

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

update

root@dyntest-amd-6000-8gb /var/www/node/dyntest # ps ax | grep mysqld
 7928 pts/0    S+     0:00 grep mysqld
28942 ?        S      0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
29800 ?        Sl    17:31 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/lib/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

Can you post the output of ps ax | grep mysqld I'd like to see what tags mysql is running with — Pez Cuckow
– Pez Cuckow, Commented Jan 18, 2014 at 16:57
--port=3306 vs. port : 3308,. Change the port in your script to 3306 and it should work. — darthmaim
– darthmaim, Commented Jan 18, 2014 at 18:37

Victor Dodon · Accepted Answer · 2014-10-20 12:42:06Z

45

I know this question has been answered, but for me the problem was that the mysql server listens on a Unix socket not on a tcp socket. So the solution was to add:

port: '/var/run/mysqld/mysqld.sock'

to the connection options.

answered Oct 20, 2014 at 12:42

Victor Dodon

1,8944 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

kjh Over a year ago

Tested this solution on Ubuntu and it worked for me as well over the other solutions.

windmaomao Over a year ago

for osx MAMP, the port is /Applications/MAMP/tmp/mysql/mysql.sock

rlemon Over a year ago

just chiming in for future readers: This solves the issue connecting to mysql on Angstrom Distribution as well via node (at least for me on a BeagleBoneBlack it did) and the path was actually /tmp/mysql.sock

Hasan Veli Soyalan Over a year ago

For centos port: '/var/lib/mysql/mysql.sock' works fine, thanks

intumwa Over a year ago

Thanks, @rlemon, it's the same for Mac.

|

Pez Cuckow · Accepted Answer · 2014-01-18 16:59:39Z

13

If this has worked before, my first guess would be that you've already got a copy of your node.js script running in the background which is holding the connection.

I believe connection refused is a tcp/ip error message, rather than something from MySQL which suggests that it is either not running or is running on another port or with sockets.

Could you try telnet'ing to port 3308? To see if the server is running on that port?

telnet localhost 3308

Can you also try:

mysql -hlocalhost -uroot -pxxx

edited Jan 18, 2014 at 16:59

answered Jan 18, 2014 at 16:54

Pez Cuckow

14.5k19 gold badges83 silver badges132 bronze badges

5 Comments

clarkk Over a year ago

running this from the command line works fine mysql -hlocalhost -uroot -pxxx.. How can I kill all node.js scripts?!

clarkk Over a year ago

sorry mysql -hlocalhost -P 3308 -uroot -pxxx forgot the port.. but it works

clarkk Over a year ago

Have now tried to create a 'root'@'%' with all privileges granted.. same error.. hmm..

clarkk Over a year ago

hmm.. I don't know why, but when I change port to the default port 3306 it works!? fact is that in the PHP application it connects to port 3308 and port 3308 is also assigned in my.cnf...

Pez Cuckow Over a year ago

I'd like to guess PHP is actually using sockets and 3308 in the PHP config is incorrect.

JoSSte · Accepted Answer · 2018-12-24 08:25:59Z

12

Overview

For anyone else having this problem and is running mamp. I suspected the problem had to do with the network and not MySQL or Node.js.

Solution

If you open MAMP and click MySQL in the left navigation panel it will pull up the MySQL options page. In the center of the page you will see a checkbox that says,

"Allow network access to MySQL".

Check this box and then restart your MAMP. At this point you can now test your connection to MySQL with telnet or a node.js script.

Hint

Remember you can check which port your MySQL is running on by opening MAMP and clicking the ports link on the left navigation panel.

Visual Aid

edited Dec 24, 2018 at 8:25

JoSSte

3,4527 gold badges43 silver badges63 bronze badges

answered Feb 7, 2017 at 4:05

wuno

9,90521 gold badges106 silver badges183 bronze badges

Comments

Mikayil · Accepted Answer · 2023-01-16 22:23:48Z

9

Mac OS on M1 MacBook Pro here with MySQL installation via brew:

Changing the host from 'localhost' to '127.0.0.1' and creating a different user with a password solved this issue for me. For some reason I cannot connect to my DB with root user and no password. I created the new user on MySQL Workbench, but you can create a new user with admin privileges via the mysql CLI also. Just google it.

This is how my backend looks:

const express = require('express');
const mysql = require('mysql');
const app = express();
const port = 3500;

const db = mysql.createConnection({
    host: '127.0.0.1',
    user: 'admin',
    password: 'admin',
});
db.connect((err) => {
    if (err) throw err;
    console.log('connected to database');
});

app.listen(port, () => {
    console.log('server listening on port 3500');
});

answered Jan 16, 2023 at 22:23

Mikayil

1051 silver badge5 bronze badges

3 Comments

Ahmad T. Over a year ago

Thanks! I only needed to replace localhost with 127.0.0.1 or 0.0.0.0 to make it work.

Alexey Sh. Over a year ago

127.0.0.1 did the trick for me. It's weird because it worked with localhost for a while. Mac OS 13.6 Intel

Jeff Lowery Over a year ago

This also solved my problem running Node on ChromeOS Debian container (penguin).

chick3n0x07CC · Accepted Answer · 2019-06-12 19:20:51Z

I wanted to comment my solution here, just in case there were people as newbie as me in databases.

I was getting this error because I had installed the mysql NPM package correctly but I hadn't installed any implementation of MySQL on my computer (I didn't know I had to).

I'm using Arch Linux so, in my case, with the NPM package already installed in my project, I did pacman -Syu mariadb (MariaDB is the default implementation of MySQL in Arch Linux) and then configured it following the guide.

Then, you can use the root user you just configured or create a new one to use in your project. For the latter:

Enter mysql CLI by running mysql -u root -p.
Enter the password for root user.
Create a new database with CREATE DATABASE mydatabase;.
Create a new user with CREATE USER test IDENTIFIED BY "testpass";.
Grant privileges to test user to use your new database with GRANT ALL PRIVILEGES ON mydatabase.* TO test@localhost IDENTIFIED BY "testpass";. See for more information on this.

And then, in my project, I would have:

let connection = mysql.createConnection({
    host: "localhost",
    user: "test",
    password: "testpass",
    database: "mydatabase"
});

Obsidian Age · Accepted Answer · 2017-05-18 04:15:48Z

2

For some very odd reason, my computer only allowed me to have port 3306 as default port for my connection in order for it to work.

Screenshot

edited May 18, 2017 at 4:15

Obsidian Age

42.6k11 gold badges54 silver badges76 bronze badges

answered May 17, 2017 at 22:45

dhan30

291 bronze badge

2 Comments

John'Sters Over a year ago

Not sure, but this could be because your Apache Web Server was not running.

ozanmuyes Over a year ago

Please do not store credentials in code. Every time someone does that a baby penguin suffers...

teledoc · Accepted Answer · 2021-01-26 21:29:34Z

If you are using MAMP please note that mysql default db_port is set to 8889 so you for this purpose I had to change it to 3306 (or whatever your app mysql db_port is set to).

My issue was that node server was connecting using port 3306, so it was giving the error below then crashing but mysql was up and seemed to establishing a connection through localhost, although I couldnt test it because node server was down.

errno: -61, code: 'ECONNREFUSED', syscall: 'connect', address: '127.0.0.1', port: 3306, fatal: true

Once I changed the port on MAMP mysql from 8889 to 3306, node server established connection through port 3000 and giving the statement below:

server running on port 3000 The solution is: 2

Anton Krug · Accepted Answer · 2021-05-06 22:34:26Z

0

I use Windows 10 and I have Windows Subsystem For Linux (WSFL). I can execute my project from the WSFL console, but my MySQL is installed in Windows and they can not connect, however when I execute my project from a Windows console then it works without any problems.

edited May 6, 2021 at 22:34

Anton Krug

1,7992 gold badges25 silver badges40 bronze badges

answered May 5, 2021 at 2:43

Daniel

1

Comments

JB0x2D1 · Accepted Answer · 2024-12-17 19:56:00Z

0

I got ECONNREFUSED ::1:3306 on Ubuntu Server when I had

host="localhost"

For me the fix was

host="127.0.0.1"

Because my configs had bind-address 127.0.0.1 and no IPv6 address, when localhost got translated to IPv6 ::1 instead of IPv4 127.0.0.1 it wouldn't connect.

I found the bind address like this:

$ cd /etc/mysql/
$ grep -R bind-address

answered Dec 17, 2024 at 19:56

JB0x2D1

9901 gold badge9 silver badges24 bronze badges

Collectives™ on Stack Overflow

node.js mysql error: ECONNREFUSED

error

update

9 Answers 9

6 Comments

5 Comments

Comments

3 Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

error

update

9 Answers 9

6 Comments

5 Comments

Comments

3 Comments

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related