node.js - Can't connect to MYSQL database with Sequelize

Question

I'm starting at Node.js and i'm trying to make a simple connection with Sequelize based on its documentation (http://docs.sequelizejs.com/manual/installation/getting-started.html#installation). Here my db.js file :

const Sequelize = require('sequelize')

const db = new Sequelize('chat','root','root',{
    host: 'localhost',
    port: 3306,
    dialect: 'mysql'

});

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

When executing this code, I have no success nor error message, just a message indicating 'String base operators deprecated' but nothing important i think.

I tried changing localhost to 127.0.0.1, remove port number and multiples thread but i'm stucked here...

Your code is correct.

codejockie
– codejockie

2017-10-25 19:45:43 +00:00
Commented Oct 25, 2017 at 19:45 — codejockie
– codejockie, Commented Oct 25, 2017 at 19:45

codejockie · Accepted Answer · 2017-10-25 19:56:16Z

1

Tested your code and all seemed to work fine, it connected successfully to the database instance I have running.
You might want to ensure mysql2 package is installed. Also check that the database chat has been created in MySQL workbench, and ensure the password is correct.

edited Oct 25, 2017 at 19:56

answered Oct 25, 2017 at 19:48

codejockie

11.1k5 gold badges52 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

node.js - Can't connect to MYSQL database with Sequelize

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