egg-sequelize连接数据库报错

egg-sequelize连接数据库报错

egg的文档写错了一个地方,经过不断的实验,花了很久的时间才改正这个配置大坑,简直是太坑了
文档中配置如下config/config.default.js:

config.sequelize = {
   
   
  dialect: 'mysql',
  host: '127.0.0.1',
  port: 3306,
  database: 'egg-sequelize-doc-default',
};

按照上面这样配置的话一直报一个错误,SequelizeAccessDeniedError: ER_ACCESS_

解决eggjs 报错 2025-07-11 13:54:44,758 ERROR 45268 nodejs.SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: NO) at ConnectionManager.connect (E:\likeadmin_node\server\node_modules\sequelize\src\dialects\mysql\connection-manager.js:118:17) at processTicksAndRejections (node:internal/process/task_queues:95:5) at async ConnectionManager._connect (E:\likeadmin_node\server\node_modules\sequelize\src\dialects\abstract\connection-manager.js:332:24) at async E:\likeadmin_node\server\node_modules\sequelize\src\dialects\abstract\connection-manager.js:250:32 at async ConnectionManager.getConnection (E:\likeadmin_node\server\node_modules\sequelize\src\dialects\abstract\connection-manager.js:280:7) at async E:\likeadmin_node\server\node_modules\sequelize\src\sequelize.js:638:26 at async Sequelize.authenticate (E:\likeadmin_node\server\node_modules\sequelize\src\sequelize.js:972:5) at async authenticate (E:\likeadmin_node\server\node_modules\egg-sequelize\lib\loader.js:134:7) at async authenticate (E:\likeadmin_node\server\node_modules\egg-sequelize\lib\loader.js:142:7) at async authenticate (E:\likeadmin_node\server\node_modules\egg-sequelize\lib\loader.js:142:7) name: "SequelizeAccessDeniedError" parent: {"code":"ER_ACCESS_DENIED_ERROR","errno":1045,"sqlState":"28000","sqlMessage":"Access denied for user 'root'@'localhost' (using password: NO)"} original: {"code":"ER_ACCESS_DENIED_ERROR","errno":1045,"sqlState":"28000","sqlMessage":"Access denied for user 'root'@'localhost' (using password: NO)"} pid: 45268 hostname: SKY-20250605VLW
最新发布
07-12
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值