javascript - Sequelize - Please install mysql2 package manually - Stack Overflow

admin管理员组

文章数量:1400134

I have created a separate helper library to work with databases.

I am then importing this library in my project. When I am trying to create a db connection using mysql dialect, it says the following: Please install mysql2 package manually

I have installed mysql2 library in my root project but it still does not work. Do I have to install mysql2 in the helper library as well ? Is there any way to install a dependency to be visible in other libraries as well ?

I am trying to keep it as small as possible. I want the library to be configurable from the root application.

I have created a separate helper library to work with databases.

I am then importing this library in my project. When I am trying to create a db connection using mysql dialect, it says the following: Please install mysql2 package manually

I have installed mysql2 library in my root project but it still does not work. Do I have to install mysql2 in the helper library as well ? Is there any way to install a dependency to be visible in other libraries as well ?

I am trying to keep it as small as possible. I want the library to be configurable from the root application.

• javascript
• node.js
• sequelize.js

Share Improve this question Follow asked Jan 11, 2021 at 9:59 Tomas LukacTomas Lukac 2,27533 gold badges2424 silver badges4545 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 11

I found the solution. Sequelize accepts the dialect option in the constructor. All you need to do is provide it:

const connection = new Sequelize({
    host: 'localhost',
    username: 'root',
    password: 'root',
    database: 'mydb',
    dialect: 'mysql',
    dialectModule: require('mysql2'), <========= IMPORTING DIALECT
    benchmark: true
})

本文标签： javascriptSequelizePlease install mysql2 package manuallyStack Overflow