loading...
Cover image for Node.js Error: connect ECONNREFUSED - how to connect Node with phpMyAdmin

Node.js Error: connect ECONNREFUSED - how to connect Node with phpMyAdmin

upsier profile image Dan Neamtu ・2 min read

I spend more than 6 hours searching and testing, I get frustrated, angry and you know... just for 3 minutes job.

Here it's my success story with incredible persistant Node.js error connect ECONNREFUSED .

Day 1.
I run this code, and should work fine.
Node Connection

Oh, but no, some errors
Error: connect ECONNREFUSED

Usual errors, maybe 3-4 minutes. I changed host: 'localhost' to host : '127.0.0.1', port: 8080, or maybe 8000, oh yes, 3306 this is. No, not that. Oh, yes, hostname: '127.0.0.1:3306'. No. Adding database, remove database. Change every thing I can now change. Nothing.

"You should check if your XAMMP server is running", yes it is green.
Error: connect ECONNREFUSED

Maybe it is the port 8443. node app.js enter, connect ECONNREFUSED. no, it's not the port. No password, no root, no port. What can solve this?

OOhh, yes, I know, I should thinking about that. Maybe I need to put the project in root XAMPP root folder. No.

connect ECONNREFUSED

3 hours later. I need more music.

Day 2
Today, Sunday, with some first snow outside, I discovered something new. There is an IP address on my XAMPP, and maybe this is how I can solve the error.
Error: connect ECONNREFUSED

Unfortunately it was not the case.

Starting to find the real solution in my case
And after I read Yannick Motton's best answer on post host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server I found the solution.

The solution:

1. Create an user with password, and grant all provileges
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Error: connect ECONNREFUSED
This will set user: username and pass: password

2. Change localhost with your XAMPP IP (and also add username/password for user and password)
Error: connect ECONNREFUSED
Change host: "localhost" to host:"192.168.64.2", and update with user: "username", password: "password".
node app + enter
Error: connect ECONNREFUSED
Connection established It's done. Hooray.

3. Celebrate the victory
Now that your terminal print Connection established, you whould celebrate the victory with dev friends.
Error: connect ECONNREFUSED

Final thoughts

Hope this article will help you to solve the connect ECONNREFUSED error and to connect Node.js with phpMyAdmin in just a few minutes.

“Patience, persistence, and perspiration make an unbeatable combination for success.” - Napoleon Hill

Posted on by:

upsier profile

Dan Neamtu

@upsier

I create nice Bootstrap 4 Templates for independent professionals.

Discussion

markdown guide
 

I love you for this! 2 Days I search for the solution and you fixed it in 4 min!!! Thank you sir

 

Glad to help you! Thank you!

 

Wow thank you so much! I was about to give up on this error.