Set up MySQL & Sequelize

MySQL & Sequelize

npm i sequelize -g
npm i mysqsl2 -g
npm install -g sequelize-cli
npm i sequelize --save
npm i mysqsl2 --save
npm install --save sequelize-cli

sequelize init 

mysql installer (open after oracle registration): https://dev.mysql.com/downloads/installer/
vs2017 installer: https://visualstudio.microsoft.com/thank-you-downloading-visual-studio/?sku=Community&rel=15
python 3.7.3 installer: https://www.python.org/downloads/release/python-373/

add to Path: https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/mysql-installation-windows-path.html

Создание новой DB в MySQL Workbench и проверка:

CREATE DATABASE starling;
USE starling;
SELECT DATABASE();

Изменить конфиги:

const sequelize = new Sequelize(
  'db_name',
  'username', //default root
  'password', {
    host: 'localhost',
    dialect: 'mysql'
  },
);

{
  "development": {
    "username": "username",
    "password": "password",
    "database": "db_name",
    "host": "127.0.0.1",
    "dialect": "mysql"
  }
}

Ошибка Client does not support authentication protocol requested by server; consider upgrading MySQL client и её решение:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass';

Ошибка Please install mysql package manually в sequelize db:migrate:

npm i sequelize -g
npm i mysqsl2 -g
npm install -g sequelize-cli
npm i sequelize --save
npm i mysqsl2 --save
npm install --save sequelize-cli