CODEWITHSUNDEEP
mysqlnode.jsexpresssequelize.js
tonymx227
tonymx227

Reputation: 5451

Sequelize and MySQL with MAMP, I get an error

I get a problem with Sequelize for Express (node.js). I try to connect an MySQL database from MAMP Mac with Sequelize for express but it doesn't work, I don't understand why but I got an error:

Maybe I have to edit the MySQL configuration file for comment "MAMP_skip-networking_MAMP" but I don't find the MySQL Conf file for MAC...

My code:

var Sequelize = require("sequelize");

var db = new Sequelize('express', 'root', 'root', {
    host: '127.0.0.1',
    port: '3306'
});

var Project = db.define('Project', {
    date: Sequelize.DATE,
    title: Sequelize.STRING,
    description: Sequelize.TEXT
});

var project = Project.build({
    date: new Date(),
    title: 'Mon premiéé projeétçç!!',
    description: 'dsqlmdskq lkqskl ksqlmk lsmdqklm'
});

project
    .save();

Upvotes: 0

Views: 2649

Answers (2)

robertklep
robertklep

Reputation: 203241

Try using port 8889 instead of 3306.

Upvotes: 5

sdepold
sdepold

Reputation: 6231

try this:

var Sequelize = require("sequelize"); 
var db = new Sequelize('express', 'root', 'root', {
  host: '127.0.0.1',
  port: '3306' 
});

var Project = db.define('Project', {
  date: Sequelize.DATE,
  title: Sequelize.STRING,
  description: Sequelize.TEXT 
});

db.sync().success(function() {
  var project = Project.build({
    date: new Date(),
    title: 'Mon premiéé projeétçç!!',
    description: 'dsqlmdskq lkqskl ksqlmk lsmdqklm' 
  });

  project.save();
})

Upvotes: 0

Related Questions