Connecting to mysql in an electron app: ER_NOT_SUPPORTED_AUTH_MODE

Question

I am new to all three Electron Mysql and JS

I was trying to connect to my database "school" with table "student"

Kindly help

Index.js

const electron = require('electron')
const { app, BrowserWindow } = electron
const url = require('url')
const path = require('path')
app.on('ready', _ => {
    var mysql = require('mysql')
    var connection = mysql.createConnection({
       host  : 'localhost',
       users : 'root',
       password: '123456',
       database: 'school'
    })
    connection.connect(function(err) {
       if (err) {
         console.error('error connecting: ' + err.stack)
         return
       }
       console.log('connected as id ' + connection.threadId)
    })
})

Screenshot of Error attached

i used the command 'npm install mysql' yesterday only....I guess it will install the latest package only — sanjulgupta, Apr 16 '20 at 06:13
@namila007 tried this alter user@localhost..... and also tried alter user..... stilll not working — sanjulgupta, Apr 16 '20 at 09:24

score 1 · Accepted Answer · answered Apr 16 '20 at 09:37

Your connection profile is wrong, there is no users option. this is the working profile >

let connection = mysql.createConnection({
     host  : 'localhost',
     user : 'root',
     password: '123456',
     database: 'school'
  })

You can check npm mysql docs from here

Connecting to mysql in an electron app: ER_NOT_SUPPORTED_AUTH_MODE

1 Answers1