Cannot Connect nodejs to mysql

Question

I am running Node.js 0.10.31 on windows and my mySQL 5.5.35 on virtual-box ubuntu running on 192.168.2.150. Now to connect node js to mysql i have used following connector :

https://github.com/felixge/node-mysql

Code :

var mysql = require('mysql');
var connection = mysql.createConnection({
host : '192.168.2.150',
user : 'root',
password : '*****',
port : 3306
});

connection.connect(function(err) {
if (err) {
console.error('error connecting: ' + err.stack);
return;
}

console.log('connected as id ' + connection.threadId);
});


connection.query('SELECT 1', function(err, rows) {
// connected! (unless `err` is set)
console.log(err, rows);
});

In my.cnf file bind address is 0.0.0.0. Moreover, in the user table i have given permission to all database to [email protected]. But, still i am not able to connect from node to mysql and it gives the following error. I have even tried to the Node js 0.8.2 version but still it doesn't work. can anyone point out the error?

Error:

 error connecting: Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'
192.168.2.99' (using password: YES)
    at Handshake.Sequence._packetToError (G:\Coding_Zone\NodeJs_Work\Output\node
_modules\mysql\lib\protocol\sequences\Sequence.js:48:14)
    at Handshake.ErrorPacket (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mys
ql\lib\protocol\sequences\Handshake.js:101:18)
    at Protocol._parsePacket (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mys
ql\lib\protocol\Protocol.js:271:23)
    at Parser.write (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mysql\lib\pr
otocol\Parser.js:77:12)
    at Protocol.write (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mysql\lib\
protocol\Protocol.js:39:16)
    at Socket.Connection.connect (G:\Coding_Zone\NodeJs_Work\Output\node_modules
\mysql\lib\Connection.js:82:28)
    at Socket.EventEmitter.emit (events.js:88:17)
    at TCP.onread (net.js:397:14)
    --------------------
    at Protocol._enqueue (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mysql\l
ib\protocol\Protocol.js:135:48)
    at Protocol.handshake (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mysql\
lib\protocol\Protocol.js:52:41)
    at Connection.connect (G:\Coding_Zone\NodeJs_Work\Output\node_modules\mysql\
lib\Connection.js:109:18)
    at Object.<anonymous> (G:\Coding_Zone\NodeJs_Work\Output\mySqlTest.js:9:12)
    at Module._compile (module.js:449:26)
    at Object.Module._extensions..js (module.js:467:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Module.runMain (module.js:492:10)
    at process.startup.processNextTick.process._tickCallback (node.js:244:9)
{ [Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'192.168.2.99' (
using password: YES)]
  code: 'ER_ACCESS_DENIED_ERROR',
  errno: 1045,
  sqlState: '28000',
  fatal: true } undefined

Update :

I did try with other users also and granted them full permission in the database. But still wasn't able to resolve the error. But the strange thing is that i am able to connect with the mysql Client

Did you resolve this? Please select an answer if so.

codecowboy
– codecowboy

2015-11-22 09:56:55 +00:00
Commented Nov 22, 2015 at 9:56 — codecowboy
– codecowboy, Commented Nov 22, 2015 at 9:56

JakubKnejzlik · Accepted Answer · 2015-05-20 01:52:53Z

8

As @Paul stated correctly it's not the problem of NodeJS. If you look carefully You are giving permissions to user [email protected] (which says "user root connecting from IP 192.168.2.150"), but in error message is stated:

Access denied for user 'root'@'192.168.2.99'

Try to give your root permission for IP where your NodeJS instance is running (192.168.2.99) and it should work.

answered May 20, 2015 at 1:52

JakubKnejzlik

6,5133 gold badges43 silver badges41 bronze badges

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

2 Comments

codeinprogress Over a year ago

Hey, I am using goDaddy MySQL database and I have given permission to my IP address, in fact I have put a % wildcard to give permission to any IP that accesses the database but it still keeps showing me the same error @Naresh mentioned above. Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'user-portal'@'1.186.37.68' (using password: YES)

JakubKnejzlik Over a year ago

@codeinprogress looks like your credentials are not correct (assuming the settings and IP address is correct)

Leonardo · Accepted Answer · 2016-07-05 14:11:43Z

2

I had the same problem and I tried the other solutions listed above.

Following the recommendation of jackleekr at https://github.com/mysqljs/mysql/issues/250#issuecomment-7153315 I was able to connect, using a connection string:

var conn = mysql.createConnection('mysql://root:*******@localhost:3306/company?debug=true');

answered Jul 5, 2016 at 14:11

Leonardo

3682 silver badges17 bronze badges

Comments

Paul · Accepted Answer · 2014-09-12 12:20:27Z

1

Have you tried connecting using the same information in the MySQL client?

Are you sure the root user isn't disabled (as it often is by default)?

In short, this doesn't look like a Node problem to me, but an issue getting the right credentials and configuration.

answered Sep 12, 2014 at 12:20

Paul

36.4k12 gold badges98 silver badges124 bronze badges

2 Comments

Naresh Over a year ago

I did try with other users also and granted them full permission in the database. But still wasn't able to resolve the error. Moreover, i was able to connect with the mysql Client.

Paul Over a year ago

Are you getting anything useful in the MySQL logs? It looks like you're on a Windows box, it's possible that the access denied error is masking a block by your Firewall on port 3306; you can determine that by looking at your mysql logs to see if the logon attempt was made at all from its perspective. Finally, your MySQL settings themselves (not the user, the settings) might only allow localhost access, in which case the host value 192.168.2.150 won't work even if that's the IP of the localhost.

Sony Arouje · Accepted Answer · 2015-05-19 08:50:38Z

Adding my inputs as it might help others. I faced the same issue and below steps resolved it.

Open WorkBench
Open the connection to your database belongs.
Left hand side, under management, click Users and Privilages.
Click Add Account button, just below User Accounts list.
Enter Login Name, 'host matching' to localhost or your host name, enter password.
Goto Schema Privileges tab, click Add Entry Button and click Ok. Optionally you can specify the single database the user can access.
Select the desired rights for the user, like 'Select', 'Insert', etc
Click Apply and use the new created user to connect from Nodejs.

blagus · Accepted Answer · 2015-02-04 15:58:50Z

0

The command prompt is running with limited privilegies. Uncheck the respective box in the Command Prompt shortcut and it may work properly. I had this issue yesterday.

answered Feb 4, 2015 at 15:58

blagus

2,4154 gold badges22 silver badges22 bronze badges

Comments

pauljoe george · Accepted Answer · 2018-02-21 05:09:15Z

0

Try by changing port number to 3307

 var mysql = require('mysql');

 var connection = mysql.createConnection({

   host : '192.168.2.150',
   user : 'root',
   password : '*****',
   port : 3307

 });

connection.connect( function(error) {
  if(error) throw error;
  console.log("Connected to database");
});

It worked for me

answered Feb 21, 2018 at 5:09

pauljoe george

1

Comments

Ray · Accepted Answer · 2018-08-30 22:38:47Z

0

I too faced the same situation and the other answers didn't help me.The problem is the number of connections to the database - by default it is zero. You should change it. Steps:

Open WorkBench
Open the connection to your database belongs.
Left hand side, under management, click Users and Privilages.
Go to Account Limits.
Change Concurrent connections to your feasibility.

edited Aug 30, 2018 at 22:38

Ray

3,9947 gold badges27 silver badges37 bronze badges

answered Aug 30, 2018 at 22:17

Prudhvi Allu

1

Collectives™ on Stack Overflow

Cannot Connect nodejs to mysql

7 Answers 7

2 Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Related