Error when creating a bank with Sequelize

Question

Opa, I am creating a Rest API in Nodejs and using Sequelize as ORM only when I try to use the db:create command of the sequelize to create the database, it returns me this error:

ERROR: Dialect [Object Object] does not support db:create / db:drop

I wonder how I solve this problem, here comes the code:

module.exports = {
    dbconfig: {
        dialect: 'mysql',
        host: 'localhost:3306s',
        username: 'root',
        password: 'toor150',
        database: 'lynho_barber',
        define: {
            timestamps: true,
            underscored: true
        }
    },

};

The above code is the object that stores the sequelize parameter information

const Sequelize = require('sequelize');
const variables = require('../config/variables');

const connection = new Sequelize(variables.dbconfig);

module.exports = connection;

This above is the connection code of the sequelize.

Answer 1

The problem is that you are not initiating Sequelize in the right way. Startup of Sequelize should be done as follows:

const sequelize = new Sequelize('database', 'username', 'password', { options });

In your case:

const connection = new Sequelize(
    variables.dbconfig.database,
    variables.dbconfig.username,
    variables.dbconfig.password,
    variables.dbconfig
);

See more examples on documentation.

Answer 2

face the dialect that Voce is using in the mysql case, does not support db:create. do the following, update your npm , and reinstall the sequelize, restart your DBMS and if you have installed mysql2 reinstall it too, if not installed , install there.