mac m1 写nodejs连mysql查询报错,报Error: connect ECONNREFUSED 127.0.0.1:3306

492 阅读1分钟
const mysql=require('mysql');

//1.连接
//createConnection(服务器,用户名,密码,库)
    var db = mysql.createConnection({host:'localhost', user:'root', password:'xxx', database:'20211201'})

// 2.查询
// query(干啥,回调)
db.query('`select * from user_table`;', (err, data)=>{
    if (err)
        console.log('出错了', err);
    else
        console.log('成功了');
        console.log(JSON.stringify(data));
})

nodejs连mysql报错@2x.png