关于mysql中的node.js

Question

我在mysql数据库中使用node.js。

我使用的配置如下：

var mysql = require('mysql');
var client = mysql.createConnection({
     host: 'localhost',
     user: 'root',
     password: 'java1234',
     port: '3306',
     database: 'sample'
});

然后我得到了这些错误信息：

错误：(C:\node\test11_users\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14) at Handshake.ErrorPacket (C:\node\test11_users\node_modules\mysql\lib\protocol\sequences\Handshake.js:124:18) at Protocol._parsePacket (C：\node)，用户'root'@'localhost‘的访问被拒绝(使用密码: NO)test11_users\node_modules\mysql\lib\protocol\Protocol.js:278:23) at Parser.write (C:\node\test11_users\node_modules\mysql\lib\protocol\Parser.js:76:12) at Protocol.write (C:\node\test11_users\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket。(C:\node\test11_users\node_modules\mysql\lib\Connection.js:91:28)在套接字处。(C:\node\test11_users\node_modules\mysql\lib\Connection.js:502:10) at emitOne (events.js:116:13) at Socket.emit (events.js:211:7) at addChunk (_stream_readable.js:263:12)(C:\node\test11_users\node_modules\mysql\lib\protocol\Protocol.js:51:23) at Connection.connect (C:\node\test11_users\node_modules\mysql\lib\Connection.js:118:18) at Connection._implyConnect (C:\node\test11_users\node_modules\mysql\lib\Connection.js:453:10) at Connection(C:\node\test11_users\node_modules\mysql\lib\Connection.js:198:8) at C:\node\test11_users\routes\users.js:26:10 at Layer.handle request next (C:\node\test11_users\node_modules\express\lib\router\route.js:137:13) at Route.dispatch (C:\node\test11_users\node_modules\express\lib\router\( route.js:112:3)在Layer.handle request

但我解决不了这个问题。谢谢你简单的解释。

Answer 1

从连接选项中移除端口并尝试

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'java1234',
  database : 'sample'
});

connection.connect();