javascript - 连接express和MySQL azure时出现问题

Question

我是 Azure 新手，我已经创建了数据库服务器，并且正在尝试使用环境变量进行连接。当执行简单的 SQL 查询来检查我是否已连接时，出现以下错误:

Error: Access denied for user ''@'localhost' (using password: NO)
  code: 'ER_ACCESS_DENIED_ERROR',
  error: 1045,
  sql:undefined,
  sqlState: '28000',
  sqlMessage: "Access denied for user ''@'localhost' (using password: NO)"

index.js

import express from "express";
import {PORT} from "./config.js";
import indexRoutes from './routes/index.routes.js'

const app = express();

app.use(indexRoutes);
app.listen(PORT);

console.log(`Server listening on port ${PORT}`);

config.js

import dotenv from 'dotenv'

dotenv.config()

export const config = {
    db: {
        host: process.env.HOSTNAME,
        user: process.env.USER,
        password: process.env.PASSWORD,
        database: process.env.DATABASE,
        port: process.env.PORT
    }
};


export const PORT = 4000;

index.routes.js

import { Router } from "express";
import { pool } from "../db.js";

const router = Router();

router.get("/ping", async (req, res) => {
  const result = await pool.query("SELECT 1 + 1 as result");
  console.log(result);
  res.json("ping");
});

export default router;

db.js

import {createPool} from 'mysql2/promise';


export const pool = createPool({

});

Answer 1

您应该使用像sequelize或typeorm这样的ORM来使用express执行数据库交互，它们让您的生活变得非常轻松