mac_05185 2022-08-31 16:11 采纳率: 67.1%
浏览 89
已结题

node运行nom run dev提示数据库连接失败异常

https://gitee.com/ecitlm/splider

项目地址如上,拉取到本地,但是在npm run dev 这一步报错,提示数据库连接失败:

img

错误代码如下:

[nodemon] 2.0.19
[nodemon] to restart at any time, enter `rs`
[nodemon] watching path(s): *.*
[nodemon] watching extensions: js,mjs,json
[nodemon] starting `node src/app.js`
false
Web server started at port 3001!
Unable to connect to the database: AccessDeniedError [SequelizeAccessDeniedError]: Access denied for user 'root'@'localhost' (using password: NO)
    at ConnectionManager.connect (E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\dialects\mysql\connection-manager.js:94:17)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async ConnectionManager._connect (E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\dialects\abstract\connection-manager.js:220:24)
    at async E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\sequelize.js:301:26
    at async Sequelize.authenticate (E:\vue_test\node_spliderApi\splider\node_modules\_sequelize@6.21.4@sequelize\lib\sequelize.js:453:5) {
  parent: Error: Access denied for user 'root'@'localhost' (using password: NO)
      at Packet.asError (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:456:32)
      at PacketParser.onPacket (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:85:12)
      at PacketParser.executeStart (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:92:25)
      at Socket.emit (node:events:513:28)
      at addChunk (node:internal/streams/readable:315:12)
      at readableAddChunk (node:internal/streams/readable:289:9)
      at Socket.Readable.push (node:internal/streams/readable:228:10) {
    code: 'ER_ACCESS_DENIED_ERROR',
    errno: 1045,
    sqlState: '28000',
    sqlMessage: "Access denied for user 'root'@'localhost' (using password: NO)",
    sql: undefined
  },
  original: Error: Access denied for user 'root'@'localhost' (using password: NO)
      at Packet.asError (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:456:32)
      at PacketParser.onPacket (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:85:12)
      at PacketParser.executeStart (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (E:\vue_test\node_spliderApi\splider\node_modules\_mysql2@2.3.3@mysql2\lib\connection.js:92:25)
      at Socket.emit (node:events:513:28)
      at addChunk (node:internal/streams/readable:315:12)
      at readableAddChunk (node:internal/streams/readable:289:9)
      at Socket.Readable.push (node:internal/streams/readable:228:10) {
    code: 'ER_ACCESS_DENIED_ERROR',
    errno: 1045,
    sqlState: '28000',
    sqlMessage: "Access denied for user 'root'@'localhost' (using password: NO)",
    sql: undefined
  }
}

本地navicat新建数据库,增删改查都没啥问题;才开始接触前端这块,还请各位指教

  • 写回答

5条回答 默认 最新

  • 易书生 2022-09-01 10:48
    关注

    那是你连接的数据库的账号密码不对,
    修改 .env.development 文件下 #database部分的配置
    把数据库地址,数据库名,账号,密码等改成自己的,就可以了

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

问题事件

  • 已结题 (查看结题原因) 9月1日
  • 已采纳回答 9月1日
  • 赞助了问题酬金5元 9月1日
  • 赞助了问题酬金5元 8月31日
  • 展开全部

悬赏问题

  • ¥20 西门子S7-Graph,S7-300,梯形图
  • ¥50 用易语言http 访问不了网页
  • ¥50 safari浏览器fetch提交数据后数据丢失问题
  • ¥15 matlab不知道怎么改,求解答!!
  • ¥15 永磁直线电机的电流环pi调不出来
  • ¥15 用stata实现聚类的代码
  • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效
  • ¥15 悬赏!微信开发者工具报错,求帮改