Cannot specify database when using an existing connection pool

[RedSpid3r]

I am trying to using my existing connection pool with express-mysql-session, however, in doing so i am unable to specify the database name.

My app connected to multiple databases which is why I am not setting database name in mysql2 createPool options.

    const sessionStore = new MySQLStore({ database: "db_name" }, pool);
    app.use(
        session({
            key: `APP_${process.env.NODE_ENV}`,
            secret: process.env.SESSION_SECRET,
            store: sessionStore,
            resave: false,
            saveUninitialized: false,
            clearExpired: true,
            checkExpirationInterval: 900000,
            cookie: {
                secure: process.env.NODE_ENV === "production" ? true : false,
                maxAge: 2629800000,
            },
        })
    );

this results in:

  code: 'ER_NO_DB_ERROR',
  errno: 1046,
  sql: "SELECT `data` AS data, `expires` as expires FROM `sessions` WHERE `session_id` = '[REDACTED]'",
  sqlState: '3D000',
  sqlMessage: 'No database selected'

Is there a way to make this work or do i need to keep using 2 separate connection pools?

[chill117]

When you pass an existing pool or connection object to the MySQLStore constructor, the module will not create a new pool internally - it will use the one that you provided. So the database-related options (e.g. database) will not be used. Create a new pool object with the other database name and then pass that to the constructor.