Connect Sequelize without a password to MySQL?

Question

Currently I am trying different ORMs, and in between Sequelize.

I have an application in development that does not have any password for the root user, but this is for development, is it mandatory to add a password to the configuration to connect with Sequelize?

By command line I just do:

mysql -u root

and thats enough to get it up and running and play locally.

Answer 1

It clearly depends on how you initialize the connection.

You can just declare the username as root and the password as null.

{
    "development": {
        "username": "root",
        "password": null,
        "database": "database_development",
        "host": "127.0.0.1",
        "dialect": "mysql"
    },
    "test": {
        "username": "root",
        "password": null,
        "database": "database_test",
        "host": "127.0.0.1",
        "dialect": "mysql"
   },
    "production": {
        "username": "root",
        "password": null,
        "database": "database_test",
        "host": "127.0.0.1",
        "dialect": "mysql"
   }
}

Now if you just instantiate a Sequelize object you can try skipping the password parameter entirely like below.

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', null, {
   host: 'localhost',
   dialect: 'mysql' | 'sqlite' | 'postgres' | 'mssql',
       operatorsAliases: false,
   pool: {
       max: 5,
       min: 0,
       acquire: 30000,
       idle: 10000
   },
});