ER_NOT_SUPPORTED_AUTH_MODE - MySQL server

Question

Failed at Connecting Node.js Server to MySQL-Database

---

        I had MariaDB" installed on a "Node.js Server", but decided that I wanted to use a SQL Database instead. I uninstalled, and completely removed "MariaDB", after which, I proceeded to install the "Community Ed." "MySQL Database". After going through the entire *'MySQL Setup Process'**, I made several attempts to connect to the database via a JavaScript document that implemented the de facto code snippet for a JS DB Connection — my DB-connection document is posted as a code snippet bellow — shown in the code snippet bellow. Disappointingly, the JS/SQL connection failed at each attempt.

Here is the Failed Connection Error Message that I received:

---

 "ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server. Consider upgrading MariaDB client."  

JS/SQL Connection Snippet that I am using:

---

     var mysql = require('mysql');          var connection = mysql.createConnection({         host     : 'localhost',         user     : 'root',         password : '********',         database : 'foobarDb'     });   

Answer 1

For MySQL v8.0 use the following:

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

Answer 2

You need to reconfigure the Quick Action Settings by clicking the "Reconfigure Link" as shown in the screenshot below. From there, select "Legacy password" for v5.1.

The cause of the error:

---

You installed the latest "MySQL Version", v8.0. The latest version has a different encryption plugin for authenticating users at login. 5.6, and 5.1 revert to the prior encryption algorithms. Please note, 5.6 & 5.1 have several security vulnerabilities reported by oracle.