nodeJ配置mysql
//引入mysql
let mysql = require('mysql');
// 创建连接池
let connection = mysql.createConnection({
host: 'localhost',
user: 'root',
port: '3306',
password: '',
database: 'admin'
});
connection.connect((err) => {
//使用连接池
if (err) {
console.log("数据库连接失败")
console.log('错误信息为:' + err);
} else {
console.log("数据库连接成功")
}
});
// 导出连接池对象
module.exports = connection;