MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client


Mysql Problem Overview

I can't make a simple connection to the server for some reason. I install the newest MySQL Community 8.0 database along with Node.JS with default settings.

This is my node.js code

    var mysql = require('mysql');
    var con = mysql.createConnection({
      host: "localhost",
      user: "root",
      password: "password",
      insecureAuth : true
    con.connect(function(err) {
      if (err) throw err;

Below is the error found in Command Prompt:

C:\Users\mysql-test>node app.js
            throw err; // Rethrow non-MySQL errors
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (C:\Users\mysql-
    at Handshake.ErrorPacket (C:\Users\mysql-test\node_mo
    at Protocol._parsePacket (C:\Users\mysql-test\node_mo
    at Parser.write (C:\Users\mysql-test\node_modules\mys
    at Protocol.write (C:\Users\mysql-test\node_modules\m
    at Socket.<anonymous> (C:\Users\mysql-test\node_modul
    at Socket.emit (events.js:159:13)
    at addChunk (_stream_readable.js:265:12)
    at readableAddChunk (_stream_readable.js:252:11)
    at Socket.Readable.push (_stream_readable.js:209:10)
    at Protocol._enqueue (C:\Users\mysql-test\node_module
    at Protocol.handshake (C:\Users\mysql-test\node_modul
    at Connection.connect (C:\Users\mysql-test\node_modul
    at Object.<anonymous> (C:\Users\mysql-test\server.js:
at Module._compile (module.js:660:30)
at Object.Module._extensions..js (module.js:671:10)
at Module.load (module.js:573:32)
at tryModuleLoad (module.js:513:12)
at Function.Module._load (module.js:505:3)
at Function.Module.runMain (module.js:701:10)

I've read up on some things such as:

But I am still not sure how to fix my problem. Any help would be appreciated :D

Mysql Solutions

Solution 1 - Mysql

Execute the following query in MYSQL Workbench

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

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;

Try connecting using node after you do so.

If that doesn't work, try it without @'localhost' part.

Solution 2 - Mysql


  1. If you just want to get rid of the error, at the cost of risking the security of the project (e.g. it's just a personal project or dev environment), go with @Pras's answer -- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' and then flush privileges
  2. If you want to have a fix for it, without knowing why, just install and use mysql2 (instead of mysql) and use it -- npm i mysql2, and mysql = require('mysql2');.
  3. If you are a curious developer who is always eager to learn, keep reading ... :)

What's going on?

Let's first make it clear what's going on.

MySQL 8 has supports pluggable authentication methods. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password (source). It should be obvious that using a crypto algorithm with several handshakes is more secure than plain password passing that has been there for 24 years!

Now, the problem is mysqljs in Node (the package you install with npm i mysql and use it in your Node code) doesn't support this new default authentication method of MySQL 8, yet. The issue is in here: and is still open, after 3 years, as of July 2019.

UPDATE June 2019: There is a new PR in mysqljs now to fix this!

UPDATE Feb 2020: Apparently it's scheduled to come in version 3 of mysqljs.

UPDATE July 2020: Apparently it's still not in yet (as of April 2020 at least), but it's claimed that node-mysql2 is supporting Authentication switch request. Please comment below if node-mysql2 is working fine for this issue -- I will test it later myself.

UPDATE April 2021: It seems like the issue is still there and just 3 days ago, someone created a fork and made it there -- yet not official in the mysql.js package. Also, as per the comments below, it seems like mysql2 package is working fine and supporting Authentication-switch properly.

Your Current Options

That's what everybody suggests here (e.g. top answer above). You just get into mysql and run a query saying root is fine using old mysql_native_password method for authentication:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password ...

The good thing is, life is going to be simple and you can still use good old tools like Sequel Pro without any issue. But the problem is, you are not taking advantage of a more secure (and cool, read below) stuffs available to you.

Option 2) [Meh...] Replace "Node" package with MySQL Connecter X DevAPI

MySQL X DevAPI for Node is a replacement to Node's Mysqljs package, provided by official guys.

It works like a charm supporting caching_sha2_password authentication. (Just make sure you use port 33060 for X Protocol communications.)

The bad thing is, you have left our old mysql package that everyone is so used to and relies on.

The good thing is, your app is more secure now and you can take advantage of a ton of new things that our good old friends didn't provide! Just check out the tutorial of X DevAPI and you'll see it has a ton of new sexy features that can come in handy. You just need to pay the price of a learning curve, which expectedly comes with any technology upgrade. :)

PS. Unfortunately, this XDevAPI Package doesn't have types definition (understandable by TypeScript) yet, so if you are on typescript, you will have problems. I tried to generate .d.ts using dts-gen and dtsmake, but no success. So keep that in mind.

As mentioned above, mysql package (NPM package link) is still having this issue (as of April 2021). But mysql2 package (NPM package link) is not. So probably the following should be the one-liner answer!

npm un mysql && npm i mysql2

Please note that mysql2 is a forked work off of the popular mysql, but its popularity (620K downloads per week for mysql2 in April 2020) has got close to the original package (720K download per week for mysql in April 2021) that making the switch seems reasonable!


Solution 3 - Mysql

Using the old mysql_native_password works:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword';
-- or
CREATE USER 'foo'@'%' IDENTIFIED WITH mysql_native_password BY 'bar';
-- then

This is because caching_sha2_password is introduced in MySQL 8.0, but the Node.js version is not implemented yet. You can see this pull request and this issue for more information. Probably a fix will come soon!

Solution 4 - Mysql

Full Steps For MySQL 8

Connect to MySQL

$ mysql -u root -p
Enter password: (enter your root password)

Reset your password

(Replace your_new_password with the password you want to use)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
mysql> quit

Then try connecting using node

Solution 5 - Mysql

Although the accepted answer is correct, I'd prefer creating a new user and then using that user to access the database.

create user nodeuser@localhost identified by 'nodeuser@1234';
grant all privileges on node.* to nodeuser@localhost;
ALTER USER 'nodeuser'@localhost IDENTIFIED WITH mysql_native_password BY 'nodeuser@1234';

Solution 6 - Mysql

If you encountered this error but still wanted to use MySQL version 8. You can achieve this by telling MySQL Server to use the legacy authentication plugin when you create the database using Docker.

So, your compose file will look like this:

# Use root/example as user/password credentials

version: '3.1'


    image: mysql:8.0.15
    command: --default-authentication-plugin=mysql_native_password
    restart: always
       MYSQL_ROOT_PASSWORD: 'pass'
       MYSQL_DATABASE: 'db'
       MYSQL_USER: 'user'
       MYSQL_PASSWORD: 'pass'
      - 3318:3306
    # Change this to your local path
      - ~/Database/ORM_Test:/var/lib/mysql

Solution 7 - Mysql

If the ALTER USER ... command line doesn't work for you AND if you are using Windows 10 then try to follow those steps:

  1. Type MySQL in the windows search bar

  2. Open the MySQL Windows Installer - Community

  3. Look for "MySQL server" and click on Reconfigure step 3

  4. Click on "Next" until you reach the "Authentification Method" phase

  5. On the "Authentification Method" phase check the second option "Use Legacy Authentication Method" step 5

  6. Then follow the steps given by the Windows installer until the end

  7. When it's done, go into "Services" from the Windows search bar, click on "start" MySql81".

Now, try again, the connection between MySQL and Node.js should work!

Solution 8 - Mysql

Simplest answer is :-

  1. Use mysql2 instead of mysql in node

install mysql2 in node

  1. npm install mysql2

Don't downgrade your mysql db.

You are good to go. Happy Coding!

Solution 9 - Mysql

In Mysql Latest docker container

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';

Solution 10 - Mysql

> In MySQL 8.0, caching_sha2_password is the default authentication > plugin rather than mysql_native_password. ...

Most of the answers in this question result in a downgrade to the authentication mechanism from caching_sha2_password to mysql_native_password. From a security perspective, this is quite disappointing.

This document extensively discusses caching_sha2_password and of course why it should NOT be a first choice to downgrade the authentication method.

With that, I believe Aidin's answer should be the accepted answer. Instead of downgrading the authentication method, use a connector which matches the server's version instead.

Solution 11 - Mysql

Downgrading might not be a good option as:

  1. Its upgraded for a reason (To provide better authentication).
  2. You might not have enough permissions to make such changes.

You can use mysql2 package in place of mysql. Its mostly API compatible with mysqljs. Also, it has promises support.

Use it like: const mysql = require('mysql2/promise') (for promise based methods)

You can read more about mysql2 here:

Solution 12 - Mysql

If you are using docker, it worked for me!

in the docker-compose.yml add the following lines:

   command: --default-authentication-plugin=mysql_native_password
   restart: always

after that, down the container and up again.

Solution 13 - Mysql

For existing mysql 8.0 installs on Windows 10 mysql,

  1. launch installer,

  2. click "Reconfigure" under QuickAction (to the left of MySQL Server), then

  3. click next to advance through the next 2 screens until arriving

  4. at "Authentication Method", select "Use Legacy Authentication Method (Retain MySQL 5.x compatibility"

  5. Keep clicking until install is complete

Solution 14 - Mysql

Original documentation you can find here :

'use strict';

const mysqlx = require('@mysql/xdevapi');

const options = {
  host: 'localhost',
  port: 33060,
  password: '******',
  user: 'root',
  schema: 'yourconference'

  .then(session => {
  }).catch(err => {

Solution 15 - Mysql

I have MYSQL on server and nodejs application on another server

Execute the following query in MYSQL Workbench

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

Solution 16 - Mysql

With MySQL 8+ the new default authentication is caching_sha2_password instead of mysql_native_password. The new and more secure authentication method is not supported by the native mysql package yet, but you should consider using the package @mysql/xdevapi instead, which is officially supported and maintained by Oracle.

To install the new package, run:

npm install @mysql/xdevapi --save --save-exact

To connect to the database and INSERT some VALUES:

const mysqlx = require('@mysql/xdevapi');
var myTable;

        user: 'root',
        password: '*****',
        host: 'localhost',
        port: 33060
    .then(function (session) {

    // Accessing an existing table
    myTable = session.getSchema('Database_Name').getTable('Table_Name');

    // Insert SQL Table data
    return myTable
        .insert(['first_name', 'last_name'])
        .values(['John', 'Doe'])

The official package documentation can be found here:

Solution 17 - Mysql

In addition to the above answers ; After executing the below command

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

If you get an error as :

[ERROR] Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted

Then try in the cmd as admin; set the path to MySQL server bin folder in the cmd

set path=%PATH%;D:\xampp\mysql\bin;

and then run the command :

mysql_upgrade --force -uroot -p

This should update the server and the system tables.

Then you should be able to successfully run the below commands in a Query in the Workbench :

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

then remember to execute the following command:

flush privileges;

After all these steps should be able to successfully connect to your MySQL database. Hope this helps...

Solution 18 - Mysql

I just run into this problem too, with all the MySQL re-config mentioned above the error still appears. It turns out that I misspelled the database name.

So be sure you're connecting with the right database name especially the case.

Solution 19 - Mysql

For MySql 8 instead of changing the authentication for the root user create a new user with all privileges and change the authentication method from caching_sha2_password to mysql_native_password. Please check the documentation by Ochuko Ekrresa for detailed steps.

Summary of Steps:

  1. Login as root mysql -u root -p
  2. Create new user CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
  3. Grand all permission GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';

Check the above-mentioned document link to get details on giving specific privileges.

  1. Reload the privileges FLUSH PRIVILEGES;
  2. Quit MySql quit; and login again with mysql -u [newuser] -p;
  3. Last step change the authentication ALTER USER 'newuser'@'localhost' IDENTIFIED WITH mysql_native_password by 'password';

Additional Info: For me after changing authentication for root, I was faced with Authentication issues and was unable to login. So I reset my password(Reset password doc).

Solution 20 - Mysql

I would recommend to use Knexjs with MySQL2.

And you have good to go with caching_sha2_password auth method.

Query with Knex:

const response = await knex.raw("SELECT * FROM USERS");


If you don't have a remote user then use CREATE keyword instead of ALTER and just put the below command on the terminal.

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpass';
GRANT ALL ON *.* TO 'root'@'%';
Flush privileges;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpass';
GRANT ALL ON *.* TO 'root'@'localhost';
Flush privileges;

All done :)

Solution 21 - Mysql

Check privileges and username/password for your MySQL user.

For catching errors it is always useful to use overrided _delegateError method. In your case this has to look like:

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  insecureAuth : true

var _delegateError = con._protocol._delegateError;

con._protocol._delegateError = function(err, sequence) {
    if (err.fatal)
        console.trace('MySQL fatal error: ' + err.message);

    return, err, sequence);

con.connect(function(err) {
  if (err) throw err;


This construction will help you to trace fatal errors.

Solution 22 - Mysql

Just figured this out after trying numerous things. What finally did it for me was adding require('dotenv').config() to my .sequelizerc file. Apparently sequelize-cli doesn't read env variables.

Solution 23 - Mysql

You can skip the ORM, builders, etc. and simplify your DB/SQL management using sqler and sqler-mdb.

-- create this file at: db/mdb/read.table.rows.sql
SELECT TST.ID AS "id", TST.NAME AS "name", NULL AS "report",
TST.CREATED_AT AS "created", TST.UPDATED_AT AS "updated"
const conf = {
  "univ": {
    "db": {
      "mdb": {
        "host": "localhost",
        "password": "mysqlpassword"
  "db": {
    "dialects": {
      "mdb": "sqler-mdb"
    "connections": [
        "id": "mdb",
        "name": "mdb",
        "dir": "db/mdb",
        "service": "MySQL",
        "dialect": "mdb",
        "pool": {},
        "driverOptions": {
          "connection": {
            "multipleStatements": true

// create/initialize manager
const manager = new Manager(conf);
await manager.init();

// .sql file path is path to db function
const result = await{
  binds: {
    name: 'Some Name'

console.log('Result:', result);

// after we're done using the manager we should close it
process.on('SIGINT', async function sigintDB() {
  await manager.close();
  console.log('Manager has been closed');

Solution 24 - Mysql

I had this error for several hours an just got to the bottom of it, finally. As Zchary says, check very carefully you're passing in the right database name.

Actually, in my case, it was even worse: I was passing in all my createConnection() parameters as undefined because I was picking them up from process.env. Or so I thought! Then I realised my debug and test npm scripts worked but things failed for a normal run. Hmm...

So the point is - MySQL seems to throw this error even when the username, password, database and host fields are all undefined, which is slightly misleading..

Anyway, morale of the story - check the silly and seemingly-unlikely things first!

Solution 25 - Mysql

If you have access to create a new user privilege then do so to connect normally with node.js, that is worked for me

Solution 26 - Mysql

UPDATE mysql.user SET authentication_string = PASSWORD('MY_NEW_PASSWORD')
WHERE User = 'root' AND Host = 'localhost';

This worked for me.

Solution 27 - Mysql

Just Run MySQL Server Installer and Reconfigure the My SQL Server...This worked for me.

Solution 28 - Mysql

you should use whatever schema you use for your mysql connection for your session

(async () => {
    const connection = await db.connection();
    sessionStore = new MySQLStore({

    }, connection); //just pass your connection here 

I just copy paste this here but your probably have implemented something similar to this to deal with your queries

const mysql = require('mysql')

if (!process.env.NODE_ENV || process.env.NODE_ENV === 'development') {

const dbConfig = {
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
    connectionLimit: process.env.DB_CONNECTION_LIMITS

const pool = mysql.createPool(dbConfig);

const connection = () => {
    return new Promise((resolve, reject) => {
        pool.getConnection((err, connection) => {
            if (err) {

            const query = (sql, binding) => {
                return new Promise((resolve, reject) => {
                    connection.query(sql, binding, (err, result) => {
                        if (err) {

            const release = () => {
                return new Promise((resolve, reject) => {
                    if (err) {
            resolve({ query, release });

const query = (sql, binding) => {
    return new Promise((resolve, reject) => {
        pool.query(sql, binding, (err, result, fields) => {
            if (err) {

module.exports = { pool, connection, query };

Solution 29 - Mysql

I have the same problem with MySQL and I solve by using XAMPP to connect with MySQL and stop the services in windows for MySQL (control panel - Administrative Tools - Services), and in the folder db.js (that responsible for the database ) I make the password empty (here you can see:)

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: ''

Solution 30 - Mysql

Make sure the user you are using to access your database has the privileges to do so.
GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';
Where the first star can be replaced by database name, second star specifies table. Make sure to flush privileges after.


All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionPig View Question on Stackoverflow
Solution 1 - MysqlPras View Answer on Stackoverflow
Solution 2 - MysqlAidinView Answer on Stackoverflow
Solution 3 - MysqlupupmingView Answer on Stackoverflow
Solution 4 - MysqljoshuakcockrellView Answer on Stackoverflow
Solution 5 - MysqlSiddhantView Answer on Stackoverflow
Solution 6 - MysqlRichView Answer on Stackoverflow
Solution 7 - MysqlCampaloView Answer on Stackoverflow
Solution 8 - Mysqlaashray jainView Answer on Stackoverflow
Solution 9 - MysqlMacielJrView Answer on Stackoverflow
Solution 10 - MysqlLesterView Answer on Stackoverflow
Solution 11 - MysqlSalim ShamimView Answer on Stackoverflow
Solution 12 - MysqlLeoView Answer on Stackoverflow
Solution 13 - MysqlCharles GoodwinView Answer on Stackoverflow
Solution 14 - Mysqlshivang patelView Answer on Stackoverflow
Solution 15 - MysqliomarView Answer on Stackoverflow
Solution 16 - MysqlElder DruidView Answer on Stackoverflow
Solution 17 - MysqlMadhawa JayagodaView Answer on Stackoverflow
Solution 18 - MysqlZcharyView Answer on Stackoverflow
Solution 19 - MysqlSachin KpsView Answer on Stackoverflow
Solution 20 - MysqlM. Hamza RajputView Answer on Stackoverflow
Solution 21 - MysqlB. BohdanView Answer on Stackoverflow
Solution 22 - Mysqlgbland777View Answer on Stackoverflow
Solution 23 - MysqlugateView Answer on Stackoverflow
Solution 24 - MysqlAndy SouthwellView Answer on Stackoverflow
Solution 25 - MysqlAmirouche ZeggaghView Answer on Stackoverflow
Solution 26 - MysqlTính Ngô QuangView Answer on Stackoverflow
Solution 27 - MysqlAlexander BuriasView Answer on Stackoverflow
Solution 28 - MysqlnightographView Answer on Stackoverflow
Solution 29 - MysqlMohammad JouzaView Answer on Stackoverflow
Solution 30 - MysqlNick97832954View Answer on Stackoverflow