var mysql = require('mysql');

var connection = mysql.createConnection({

    host :'127.0.0.1',

    user :'root',

    password :'123456',

    port:'3306',

    database:'yycmsfortp'

});

connection.connect(function(err)

{

    if (err)

    {

        console.info("error");

    }

    else

    {

        console.info('ok');

    }

});

connection.query('select * from roles',function(err,rows,fields){

    if (err) {console.info('query:err');return;}

    for (var i = 0; i < rows.length; i++) {

        console.info(rows[i].ROLENAME);

    }

});