mysql - 从 node.js 触发选择查询时出现 TIMEOUT 异常

Question

下面是我使用“mysql”包的节点 .js 的代码，但出现连接超时错误。帮我解决这个问题

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "10.90.103.4",
  user: "someuser",
  password: "********",
  database: "db"
});

console.log("---------------------------");
console.log(con);
console.log("---------------------------");


con.connect(function(err) {
  if (err) throw err;
  con.query("select * from CLE_EXCEPTIONRECORD where CORRELATIONID='983b2f58-e0eb-49cb-b76c-9b8107de3edc'", function (err, result, fields) {
    if (err) throw err;
    console.log(result);
  });
});

以下是我得到的错误

F:\johny\node_from_home\node_modules\mysql\lib\Connection.js:411 var err = new Error('connect ETIMEDOUT');

Error: connect ETIMEDOUT
    at Connection._handleConnectTimeout (F:\johny\node_from_home\node_modules\my
sql\lib\Connection.js:411:13)
    at Object.onceWrapper (events.js:313:30)
    at emitNone (events.js:106:13)
    at Socket.emit (events.js:208:7)
    at Socket._onTimeout (net.js:410:8)
    at ontimeout (timers.js:498:11)
    at tryOnTimeout (timers.js:323:5)
    at Timer.listOnTimeout (timers.js:290:5)
    at Protocol._enqueue (F:\johny\node_from_home\node_modules\mysql\lib\protoco
l\Protocol.js:144:48)
    at Protocol.handshake (F:\johny\node_from_home\node_modules\mysql\lib\protoc
ol\Protocol.js:51:23)
    at Connection.connect (F:\johny\node_from_home\node_modules\mysql\lib\Connec
tion.js:118:18)
    at Object.<anonymous> (F:\johny\node_from_home\testselenium_old.js:15:5)
    at Module._compile (module.js:652:30)
    at Object.Module._extensions..js (module.js:663:10)
    at Module.load (module.js:565:32)
    at tryModuleLoad (module.js:505:12)
    at Function.Module._load (module.js:497:3)
    at Function.Module.runMain (module.js:693:10)

F:\johny\node_from_home>

该表是真实的，请在下面找到

标签： mysqlnode.jsdatabasetimeout