macOS 学习 nodeJS orm连接数据库的坑 已解决

const orm = require('orm')
app.use(
  orm.express({'mysql://root:12345678@localhost:3306/mydb', {
    define: function(db, models, next) {
      next()
    }
  })
)

报错：Error: connect ECONNREFUSED 127.0.0.1:3306 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1144:16) -------------------- at Protocol._enqueue (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Protocol.handshake (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/mysql/lib/protocol/Protocol.js:51:23) at Connection.connect (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/mysql/lib/Connection.js:116:18) at Driver.connect (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/orm/lib/Drivers/DML/mysql.js:60:10) at Object.exports.connect (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/orm/lib/ORM.js:128:10) at Object.module.exports (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/orm/lib/Express.js:12:6) at Object.exports.express (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/node_modules/orm/lib/ORM.js:39:30) at Object.<anonymous> (/Users/lianyafeng/Documents/HBuilderProjects/hello-uni-资料/素材/heima_shop_server/src/app.js:17:7) at Module._compile (internal/modules/cjs/loader.js:1236:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1257:10) { errno: -61, code: 'ECONNREFUSED', syscall: 'connect', address: '127.0.0.1', port: 3306, fatal: true }

解决方法：

const orm = require('orm')
app.use(
  orm.express({"protocol":"mysql","host":"localhost","database":"mydb","port":3306,"user":"root","password":"12345678","query":{"pool":true,"debug":true},"socketPath":"/tmp/mysql.sock"}, {
    define: function(db, models, next) {
      next()
    }
  })
)