mysql - Node.js Mysql：连接失败

Question

我正在尝试将 node.js 连接到 mysql，但失败了，我已经安装了 mysql。谁能帮我 ？

const express    = require("express");
const mysql      = require('mysql');

var app = express();

var mysqlConnection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "******",
    database: "otablo",
});

mysqlConnection.connect((err)=> {
    if(!err)
    {
        console.log("Connected");
    }
    else
    {
        console.log("Connection Failed");
    }
})

app.listen(3000);

标签： mysqlnode.jsconnection

Answer 1

const mysql = require('mysql');

var app = express();
var mysqlConnection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "****",
    database: "****",
});

mysqlConnection.connect((err)=> {
    if(!err)
    {
        console.log("Connected");
    }
    else
    {
        console.log("Connection Failed");
    }
})

app.listen(3000);

您的代码工作正常，请确保您已安装所有内容并且数据库的值正确。它对我有用。