错误:Node.js v6.9.1和MYSQL中的握手不活动超时 [英] Error: Handshake inactivity timeout in Node.js v6.9.1 and MYSQL

问题描述

当我在localhost中运行时，我使用的是'mysql'和'express-myconnection'，并且使用AWS服务器的某些Internet连接可以正常工作.排除错误，但这些连接具有不错的互联网速度.

我正在使用节点版本. 6.9.1.

我读到这些问题是在较旧的版本中进行的，我确实需要知道在不更改服务器本身的情况下，开发人员可以采取任何措施来修复它.

'use strict';

var mysql      = require('mysql');
var connector  = require('express-myconnection');
var dotenv     = require('dotenv').config();

var connectionOptions = {
  host    : process.env.DB_HOST,
  database: process.env.DB_NAME,
  user    : process.env.DB_USER,
  password: process.env.DB_PASS,
  port    : process.env.DB_PORT,
};
var connection = connector(mysql, connectionOptions, 'pool'); 

module.exports = connection;

解决方案

它看起来像mySql超时，因为我的Internet连接需要更长的时间才能与服务器连接，因此基本上是路由器的DNS设置问题. /p>

I'm using 'mysql' and 'express-myconnection, when I'm running in localhost and some internet connections using AWS server its working perfectly.Yet when I'm at some of other internet connections with AWS setup its give out the error,Yet those connections have some decent internet speeds.

I'm using node ver. 6.9.1.

I read these Issues were in older versions, I do need to know if anything can be done to fix it by development side without changing server it-self.

'use strict';

var mysql      = require('mysql');
var connector  = require('express-myconnection');
var dotenv     = require('dotenv').config();

var connectionOptions = {
  host    : process.env.DB_HOST,
  database: process.env.DB_NAME,
  user    : process.env.DB_USER,
  password: process.env.DB_PASS,
  port    : process.env.DB_PORT,
};
var connection = connector(mysql, connectionOptions, 'pool'); 

module.exports = connection;

解决方案

Its looks like the mySql timeout happen because my internet connection takes a longer time to connect with the server,so basically its a DNS settings issue with the router.

这篇关于错误:Node.js v6.9.1和MYSQL中的握手不活动超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！