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); } });