SequelizeConnectionRefusedError:连接 ECONNREFUSED 127.0.0.1:3306

2022-01-19 00:00:00 node.js express mysql sequelize.js

我使用 Sequelize 作为我的节点 js 应用程序和 Mysql 数据库的 ORM，在遵循一些教程后，我添加了此代码以将 mysql 连接到节点，但在录制 npm start 后，我​​收到此错误:无法连接到数据库:{ SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306

I'm using Sequelize as an ORM to my node js app and Mysql database , after following some tutorials i m adding this code to connect mysql to the node but after taping npm start i m getting this error : Unable to connect to the database: { SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306

 const Sequelize = require('sequelize');

 // Option 1: Passing parameters separately
 const sequelize = new Sequelize('Education', 'root','', {
 host: '127.0.0.1',
 dialect: 'mysql'
 } );

  //test db 
 sequelize
.authenticate()
.then(() => {
  console.log('Connection has been established successfully.');
})
 .catch(err => {
 console.error('Unable to connect to the database:', err);
});

推荐答案

问题解决了我在 phpMyadmin 中使用端口:3307 而不是 3306

Problem solved i was using port : 3307 in phpMyadmin instead of 3306

相关文章