Node 连接mysql、redis数据库

1.mysql数据库

var mysql = require('mysql');

var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database:'mysql'
});
connection.connect();
//查询
/**
 * rows具体数据集合，fields数据表字段属性的集合
 */ 
connection.query('SELECT * from user', function(err, rows, fields) {
console.log(err);
    if (err) throw err;
    for(let i in rows[0]){
console.log(`${i}=${rows[0][i]}`);
}
});
//关闭连接

connection.end();

2.redis数据库

var client = require('redis').createClient('6379', '127.0.0.1');


client.on('error', function (err) {
  console.log('Error ' + err)
})


console.log(client.connection_options);