Skip to content

Set up MySQL & Sequelize

Sᴛѧʀʟɪɴɢ edited this page May 6, 2020 · 1 revision

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
Clone this wiki locally