// 1. 引包
var mysql = require('mysql');
// 2. 创建连接
var connection = mysql.CreateConnection({
    host: 'localhost',
    user: 'root',
    password: '8888',
    datavase: 'mysql'
});

// 3. 连接数据库
connection.connect();

// 4. 增，删，改，查
connection.query('show tables', function (error, results, firlds) {
    if (error) throw error;
    console.log('students is :', results);
});

// 5. 关闭连接
connection.end();

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-grant-tables