关于node项目在外部访问mysql数据库的请求握手超时接口返回
{
msg:"Handshake inactivity timeout",
state:false
}
解决办法:
在node的数据库链接的配置中添加:
var config = {
host: setting.cfg.host,
user: setting.cfg.user,
password: setting.cfg.password,
database: setting.cfg.database,
port: setting.cfg.db_port,
//设置超时时间解决握手不活动超时问题
connectionLimit: 1000,
connectTimeout: 60 * 60 * 1000,
acquireTimeout: 60 * 60 * 1000,
timeout: 60 * 60 * 1000,
};
var pool = mysql.createPool(config);