Sequelize error with MariaDB

Question

I am trying to setup sequelize as ORM for my MariaDB.

Here is my setup:

var sequelize = require('sequelize');

var db= new sequelize('dbname', 'user', 'pass', {
  dialect: 'mariadb'
});

When I run my app I get the following error :

/my/path/to/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:23
    throw new Error('Please install mysql package manually');
    ^

Error: Please install mysql package manually

Why is sequelize trying to connect to mysql rather than mariadb as I specified in the dialect directive? Am I missing something?

buycanna.io · Answer 1 · 2019-05-06T13:07:02.373

9

Sequelize now has the dialect mariadb, do not use mysql

npm install --save mariadb
npm install --save sequelize

Sequelize connection code...

var sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'mariadb'
})

edited May 06 '19 at 13:07

answered Dec 15 '18 at 00:04

buycanna.io

1,166
16
18

Gonzalo Bahamondez · Accepted Answer · 2018-06-07T12:57:25.363

5

Sequelize internally uses the same library to connect with MariaDB or MySQL , take a look to the documentation http://docs.sequelizejs.com/en/latest/docs/getting-started/ specifically in the section Installation.

To make it works you just need to install mysql package so:

$ npm install --save mysql2

edited Jun 07 '18 at 12:57

answered Mar 04 '16 at 17:55

Gonzalo Bahamondez

1,371
1
16
37

I went through the docs a bazillion times...don't know how I didn't see that...thank you!! – Aaron Ullal Mar 04 '16 at 18:23
1

`mysql2` required for current versions – Len Jun 07 '18 at 12:55
@indospace.io If the answer is incorrect in your opinion either say so in the comments or post your own answer, but do not edit somebody else's answer. – Dharman Sep 12 '19 at 10:56

buycanna.io · Answer 3 · 2018-09-10T10:10:17.113

3

What the previous answer fails to mention is you must also set the dialect to MySQL...dialect: mysql because dialect: mariadb does not exist.

edited Sep 10 '18 at 10:10

answered Sep 08 '18 at 22:48

buycanna.io

1,166
16
18

score 0 · Answer 4 · answered Jul 26 '20 at 15:42

0

You must install mysql or any dialect using -g.

npm i -g mysql

answered Jul 26 '20 at 15:42

Pedro Infante

81
4

score 0 · Answer 5 · answered Dec 04 '22 at 16:14

0

If you are using yarn:

yarn add mariadb

answered Dec 04 '22 at 16:14

Eli Zatlawy

678
10
24

Sequelize error with MariaDB

5 Answers5