pool连接池,pool.getConnection报错
throw err; // Rethrow non-MySQL errors
^
TypeError: Cannot read property 'query' of undefined
`
代码:
pool.getConnection((err, connection) => {
console.log('进请求啦')
let postData = req.query;//get请求参数在query里
let pageNum = parseInt(postData.pageNum || 1);// 页码
let end = parseInt(postData.pageSize || 5); // 默认页数
let start = (pageNum - 1) * end;
console.log(connection,'connection')
console.log(err,'err')
connection.query(sqlMap.article.queryAllBysu, [postData.state, postData.username, start, end], (err, result) => {
res.json(result);
})
打印出来的error是
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
搜了下是数据库有问题
链接:https://blog.csdn.net/qq_38974638/article/details/114937862
解决了