Client does not support authentication protocol requested by server consider upgrading mysql client

Question

Problem :

I am very new to node.js and MySQL and I have just started setting up and also trying out some basic code. But, I am unable to make even the simple connection to a server for some reason. I have also installed a newest MySQL Community 8.0 database along with the Node.JS with the default settings.

Below is my node.js code

    Var sql = require('sql');

    var mycon = sql.createConnection({
      host: "localhost",
      user: "root",
      password: "password",
      insecureAuth : true
    });

   mycon.connect(function(err) {
      if (err) throw err;
      console.log("Connected!");
    });

 

My Error:

“Client does not support authentication protocol requested by server consider upgrading mysql client”

 

Answer 1

You need to execute the below query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where the root is your user localhost is your URL and password is your password

Then run below query to refresh the privileges:

flush privileges;

After that you can try connecting using the node after you do so.

If that does not work then try it without @'localhost' part.

OR

In your Mysql Latest docker container try to run below query

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';

 Hope the above listed solutions will fix your issue.