node.js - node连接mysql失败

Question

利用node连接mysql一直连接不上，user和password没有错误

Answer 1

Official example, follow this method to check out err. In addition to stack, you can also look at other contents, such as message, etc., and then locate the error.

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'example.org',
  user     : 'bob',
  password : 'secret'
});
 
connection.connect(function(err) {
  if (err) {
    console.error('error connecting: ' + err.stack);
    return;
  }
 
  console.log('connected as id ' + connection.threadId);
});

Answer 2

Try writing down the port number too