DEV Community

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

Posted on

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

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

Discussion (8)

Collapse
luissotoj profile image
Luis Eduardo Sotoj

Hello, I've the same issue, but my db is on RemoteMysql.

Have your a similar scenario?

Collapse
samueltdaly profile image
Dale Dobak

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

Collapse
upsier profile image
Dan Neamtu Author • Edited

Glad to help you! Thank you!

Collapse
dignelsonx profile image
DignelsonX

Thank you so much bro!!

I had this problem on my MacBook and I had no idea how to fix it...

Thank you!

Collapse
farukdeste profile image
farukdeste

Grateful for this

Collapse
henryherrington profile image
henryherrington

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

Collapse
prezine profile image
Precious Tom

How do I get the IP Address from MAMP?

Collapse
mahmoud_bebars profile image
m.bebars

it was a quite tricky and needed to give my user lots of privileges but with some more research I got it right