Express.js调试时出现MySQL访问拒绝错误求助

我的Express.js项目在非调试模式下运行正常，但开启调试时会抛出错误：Access denied for user ''@'localhost' (using password: NO)，试了各种已知方案都没解决，求建议。

相关代码 #

index.js中的数据库连接代码 #

dotenv.config();
const connection = require("./models/index");

models目录下的连接代码 #

const mysql = require('mysql2')

const connection = mysql.createConnection({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
    port: process.env.DB_PORT,
    multipleStatements: true
});

module.exports = connection

错误栈信息 #

server is running on 8011
index.js:37
Process exited with code 1
Uncaught Error Error: Access denied for user ''@'localhost' (using password: NO)
    at asError (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/packets/packet.js:728:17)
    at execute (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/commands/command.js:29:26)
    at handlePacket (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/connection.js:481:34)
    at <anonymous> (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/connection.js:97:12)
    at executeStart (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/packet_parser.js:75:16)
    at <anonymous> (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/connection.js:104:25)
    at emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Readable.push (node:internal/streams/readable:234:10)
    at onStreamRead (node:internal/stream_base_commons:190:23)
    at callbackTrampoline (node:internal/async_hooks:130:17)
    --- TCPWRAP ---
    at init (node:internal/inspector_async_hook:25:19)
    at emitInitNative (node:internal/async_hooks:202:43)
    at Socket.connect (node:net:1176:7)
    at connect (node:net:244:17)
    at Connection (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/lib/connection.js:50:27)
    at exports.createConnection (file:///home/rohitchitampalle/auth_process/backend_auth/node_modules/mysql2/index.js:10:10)
    at <anonymous> (file:///home/rohitchitampalle/auth_process/backend_auth/src/models/index.js:4:26)
    at Module._compile (node:internal/modules/cjs/loader:1256:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1310:10)
    at Module.load (node:internal/modules/cjs/loader:1119:32)
    at Module._load (node:internal/modules/cjs/loader:960:12)
    at Module.require (node:internal/modules/cjs/loader:1143:19)
    at require (node:internal/modules/cjs/helpers:121:18)
    at <anonymous> (file:///home/rohitchitampalle/auth_process/backend_auth/src/index.js:10:20)
    at Module._compile (node:internal/modules/cjs/loader:1256:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1310:10)
    at Module.load (node:internal/modules/cjs/loader:1119:32)
    at Module._load (node:internal/modules/cjs/loader:960:12)
    at executeUserEntryPoint (node:internal/modules/run_main:81:12)
    at <anonymous> (node:internal/main/run_main_module:23:47)

排查建议 #

• 确认调试模式下的环境变量加载：检查调试配置（如VS Code的launch.json），确保配置了正确的envFile路径指向项目根目录的.env，或者在env字段里手动指定数据库相关变量。
• 验证环境变量加载状态：在dotenv.config()之后立即打印process.env.DB_USER、process.env.DB_PASSWORD等变量，对比正常运行和调试模式下的输出，确认调试时变量是否为空。
• 调整代码执行顺序：把dotenv.config()移到index.js的最顶部，确保它是第一个执行的代码，避免models模块在环境变量加载完成前就被导入。
• 检查调试工作目录：确认调试时的工作目录是项目根目录，否则dotenv会找不到.env文件。可以在调试配置中设置cwd字段指定项目根路径。
• 清除模块缓存：调试模式下可能存在模块缓存，导致未加载环境变量的旧代码被复用。可以在调试配置中添加"runtimeArgs": ["--no-cache"]，或者手动删除项目中的缓存文件。
• 核对环境变量名：确保.env文件中的变量名和代码里的完全一致，比如DB_USER不要写成DB_USERNAME，大小写和拼写错误会导致调试时读取失败。

内容的提问来源于stack exchange，提问作者Rohit Chitampalle