【how2j nodejs】如何nodejs连接mysql？

步骤 1 : 创建数据库

略

步骤 2 : 创建表结构

略

步骤 3 : 准备数据

略

步骤 4 : 准备项目目录

略

步骤 5 : 安装模块

略

步骤一到五参考：
NODE.JS系列教材 （九）- 基础 - NODEJS 如何用 MYSQL 进行 增删改查 CRUD 操作

步骤 6 : 查询所有

1. db.js

var mysql      = require("mysql");
var connection;
 
function openConnection(){
    connection = mysql.createConnection({
          host     : "127.0.0.1",
          user     : "root",
          password : "**********",
          database : "demo"
        });
    connection.connect();
}
function closeConnection(){
    connection.end();  
}
 
function showAll(){
    openConnection();
    var  sql = "SELECT * FROM category_ order by id asc";
    connection.query(sql,function (err, results) {
        if(err){
            console.log("[SELECT ERROR] - ",err.message);
            return;
        }
        if(results)
        {
            for(var i = 0; i < results.length; i++)
            {
                console.log("%d\t%s", results[i].id, results[i].name);
            }
        }  
    });
    closeConnection();     
}
 
function add(name){
    openConnection();
    var params = [null,name];  
    var  sql = "insert into category_ values (?,?)";
    connection.query(sql,params,function (err, result) {
        if(err){
         console.log("[INSERT ERROR] - ",err.message);
         return;
        }       
       console.log("insert success, the generated id is:",result.insertId);       
    });
    closeConnection(); 
}
 
function remove(id){
    openConnection();
    var params = [id]; 
    var  sql = "delete from category_ where id = ?";
    connection.query(sql,params,function (err, result) {
        if(err){
         console.log("[REMOVE ERROR] - ",err.message);
         return;
        }       
       console.log("remove id=%d success ",id);       
    });
    closeConnection(); 
}
 
function get(id){
    openConnection();
    var params = [id]; 
    var  sql = "select * from category_ where id = ?";
    connection.query(sql,params,function (err, result) {
        if(err){
         console.log("[GET ERROR] - ",err.message);
         return;
        }       
        if(result.length !=0){
            var category = {id:result[0].id,name:result[0].name};
            console.log("get category:"+ JSON.stringify(result))
        }
        else{
            console.log("not found with id :" + id)
        }
         
    });
    closeConnection(); 
}
 
function update(id,name){
    openConnection();
    var params = [name,id];
    var sql = "update category_ set name = ? where id = ?";
    connection.query(sql,params,function (err, result) {
        if(err){
         console.log("[UPDATE ERROR] - ",err.message);
         return;
        }       
         
        console.log("update success"+result.affectedRows);
 
    });
    closeConnection(); 
}
exports.showAll=showAll;
exports.add=add;
exports.get=get;
exports.update=update;
exports.remove=remove;

2. app.js

var db = require("./db");


// 查询所有
db.showAll();

// 增加
db.add("category test");

// 删除
db.remove(6);

//获取
db.get(2);
//修改
db.update(6,"category 666");
db.showAll();

参考连接

【MySQL】MySQL数据库使用Navicat修改密码

解决MySQL8.0报错Client does not support authentication protocol requested by server…问题