Connect Sequelize/Node to XAMPP Mysql

Question

I've a working script to connect and work with Sequelize on Node.js But now i'm trying to connect this to my MySQL database on XAMPP

MySQL Port on XAMPP: 3306

When i run node.js after i have configured the app.listen and the config of sequealize i get the following error

ERROR: listen EADDRINUSE :::3306

I've looked for but i didn't find much information about that, i don't know what i'm doing bad. Thanks you for every answer!

app.js

const express = require('express')
const bodyParser = require('body-parser')
const cors = require('cors')
const morgan = require('morgan')
const { sequelize } = require('./models')
const config = require('./config/config')

const app = express()
app.use(morgan('combined'))
app.use(bodyParser.json())
app.use(cors())

require('./routes')(app)

sequelize.sync()
  .then(() => {
    app.listen(config.db.options.port || 3306) // 8081 original
    console.log(`Server iniciado en puerto: ${config.db.options.port}`)
  })

config.js

module.exports = {
  db: {
    database: process.env.DB_NAME || 'intraenvios',
    user: process.env.DB_USER || 'root',
    password: process.env.DB_PASS || '',
    options: {
      dialect: process.env.DIALECT || 'mysql', // sqlite original
      host: process.env.HOST || 'localhost',
      storage: './intraenvios.sqlite',
      port: process.env.PORT || 3306 // 8081 original
    }
  }
}

EDIT:

@PrashantGupta I think it's running on 3306. Post updated, could you see the img and tell me if i'm misunderstanding something? — AtarC5
– AtarC5, Commented Sep 24, 2018 at 3:29
Your code is fine.Open CMD and try to login using this command mysql -u root -p then enter password @Natarr — Prashant Gupta
– Prashant Gupta, Commented Sep 24, 2018 at 3:34
I'm on windows and i've only installed MySQL through XAMPP. @PrashantGupta — AtarC5
– AtarC5, Commented Sep 24, 2018 at 3:35
Please Insure your mysql is running of port 3306. This error means your port is bind to other service or mysql is not running of other port @Natarr. There is option in xampp also to login mysql and you can open xampp ulr using this ` localhost/phpmyadmin` there you can check mysql running or not . — Prashant Gupta
– Prashant Gupta, Commented Sep 24, 2018 at 3:39

Lívia Gomes · Accepted Answer · 2018-12-30 14:48:37Z

2

For to connect by xampp simply, i made this:

const sequelize = new Sequelize('test', 'root', '', {
  host: "127.0.0.1",
  dialect : 'mysql',
  operatorsAliases: false
});

sequelize.authenticate().then(function(){
      console.log("sucess");
    }).catch(function(error){
      console.log("error: "+error);
});

Obs: operatorsAliases: false - To fix deprecated message of sequelize

Good Fun :)

edited Dec 30, 2018 at 14:48

answered Dec 29, 2018 at 23:33

Lívia Gomes

466 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect Sequelize/Node to XAMPP Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related