node.js 连接 mysql

 

    var mysql = require("mysql"); 
    var connection = mysql.createConnection({
        host: '127.0.0.1',
        user: "root",            //数据库用户名
        password: "12345",       //数据库密码
        database: "test",        //数据库
        port: '3306'             //端口号
    });
    connection.connect(function(err){
        if(err){
            console.log('[连接失败] - :'+err);
            return;
        }
    });
    connection.query('SELECT * FROM `mall`', function (error, rows, fields) {
        if(!error) {
            console.log(JSON.stringify(rows));
        }
    });
    //关闭连接
    connection.end();