内网Node如何用ssh方式操作外网Mysql数据库?
发布于 7 年前 作者 zgwang24 2795 次浏览 来自 问答

Node服务器在内网?而Mysql服务器在外网(腾讯云),想在内网直接操作外网数据库,该如何操作?本地已经测试可以用Navicat中的ssh方式成功连接并操作Mysql数据库。

2 回复

mysql -u lzpddd -pmypassword -h 192.168.1.88 -P 3306 -D mydb

var mysql = require('mysql');
var pool  = mysql.createConnection({
  host     : '192.168.1.88',
  user     : 'bob',
  password : 'secret',
  database : 'my_db'
});

你好,采用了这种方式: var mysql = require(‘mysql’); var connection = mysql.createConnection({ host: ‘124.*.*.127’, user : ‘root’, password : ‘90’, database : ‘offload’ }); 报了如下错误: error connectint: Error: connect ETIMEDOUT at Connection._handleConnectTimeout (/home/zgwang/project/remoteDB/node_modules/mysql/lib/Connection.js:419:13) at Socket.g (events.js:273:16) at emitNone (events.js:80:13) at Socket.emit (events.js:179:7) at Socket._onTimeout (net.js:326:8) at tryOnTimeout (timers.js:224:11) at Timer.listOnTimeout (timers.js:198:5) -------------------- at Protocol._enqueue (/home/zgwang/project/remoteDB/node_modules/mysql/lib/protocol/Protocol.js:141:48) at Protocol.handshake (/home/zgwang/project/remoteDB/node_modules/mysql/lib/protocol/Protocol.js:52:41) at Connection.connect (/home/zgwang/project/remoteDB/node_modules/mysql/lib/Connection.js:130:18) at Object.<anonymous> (/home/zgwang/project/remoteDB/remoteMysql.js:10:12) at Module._compile (module.js:413:34) at Object.Module._extensions…js (module.js:422:10) at Module.load (module.js:357:32) at Function.Module._load (module.js:314:12) at Function.Module.runMain (module.js:447:10) at startup (node.js:146:18) 我也核对了端口,端口没问题,其他可能的原因?麻烦了。

回到顶部