Using Environment Variables to initialise MySQL connection in NextJS leads to 'ER_NOT_SUPPORTED_AUTH_MODE' error

Question

I am trying to fetch data from a MySQL table. It works perfectly when I hardcode the configuration. But when I use env variables to configure it, I get the following error:

  code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  errno: 1251,
  sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  sqlState: '08004',
  fatal: true

This is my .env.local file:

MYSQL_HOST: localhost
MYSQL_USER: root
MYSQL_PASSWORD:************
MYSQL_DB:***

this is my db connections code:

const mysql = require("mysql");

var db = mysql.createConnection({
  host: process.env.MYSQL_HOST,
  user: process.env.MYSQL_USER,
  password: process.env.MYSQL_PASSWORD,
  database: process.env.MYSQL_DB,
});
db.connect((err) => {
  if (err) {
    console.log(err);
  } else {
    console.log("connected to db");
  }
});

module.exports = db;

I have tried this. No change. – Jathin Kotian Aug 17 '22 at 05:12 — Jathin Kotian, Aug 17 '22 at 05:12
@juliomalves I'm stupid. I used ':' instead of '='. – Jathin Kotian Aug 17 '22 at 05:15 — Jathin Kotian, Aug 17 '22 at 05:15

score 0 · Answer 1 · answered Aug 17 '22 at 05:16

0

The issue is resolved. I used ':' instead of '='.

answered Aug 17 '22 at 05:16

Jathin Kotian

1
1

seems like user issue. – T.S. Aug 20 '22 at 01:59

Using Environment Variables to initialise MySQL connection in NextJS leads to 'ER_NOT_SUPPORTED_AUTH_MODE' error

1 Answers1