Node JS and mysql not connecting (client does not support authentication protocol requested by server...












1















I'm trying to connect my NodeJs application with a mysql database but its not connecting for some reason.



I did install the mysql npm like this (typed this in commandline):



npm install mysql


After I installed the mysql npm I made an index.js file and in that file I tried to make the connection with my database.



This is the code inside my index.js file to make a connection with mysql:



//Gebruik mysql npm module voor de mysql database
const mysql = require('mysql');

//Geef connectie details aan
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
port : '3306',
password : 'tombal10',
database : 'fys'
});


connection.connect((err) => {
//Als er geen error is print dan 'Database is geconnect!'
if(!err)
console.log('Database is geconnect!');
//Als er wel een error is print dan 'Database connectie niet gelukt!'
else
console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
});


Then I tried to run the code and see if the connection with mysql worked. I typed this in the command line:



node index.js


This is the error message I got in the command prompt :



error image



Does anyone know how I can fix this error and get a connection with my mysqldatabase in nodejs ?



Any kind of help is appreciated










share|improve this question





























    1















    I'm trying to connect my NodeJs application with a mysql database but its not connecting for some reason.



    I did install the mysql npm like this (typed this in commandline):



    npm install mysql


    After I installed the mysql npm I made an index.js file and in that file I tried to make the connection with my database.



    This is the code inside my index.js file to make a connection with mysql:



    //Gebruik mysql npm module voor de mysql database
    const mysql = require('mysql');

    //Geef connectie details aan
    var connection = mysql.createConnection({
    host : 'localhost',
    user : 'root',
    port : '3306',
    password : 'tombal10',
    database : 'fys'
    });


    connection.connect((err) => {
    //Als er geen error is print dan 'Database is geconnect!'
    if(!err)
    console.log('Database is geconnect!');
    //Als er wel een error is print dan 'Database connectie niet gelukt!'
    else
    console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
    });


    Then I tried to run the code and see if the connection with mysql worked. I typed this in the command line:



    node index.js


    This is the error message I got in the command prompt :



    error image



    Does anyone know how I can fix this error and get a connection with my mysqldatabase in nodejs ?



    Any kind of help is appreciated










    share|improve this question



























      1












      1








      1








      I'm trying to connect my NodeJs application with a mysql database but its not connecting for some reason.



      I did install the mysql npm like this (typed this in commandline):



      npm install mysql


      After I installed the mysql npm I made an index.js file and in that file I tried to make the connection with my database.



      This is the code inside my index.js file to make a connection with mysql:



      //Gebruik mysql npm module voor de mysql database
      const mysql = require('mysql');

      //Geef connectie details aan
      var connection = mysql.createConnection({
      host : 'localhost',
      user : 'root',
      port : '3306',
      password : 'tombal10',
      database : 'fys'
      });


      connection.connect((err) => {
      //Als er geen error is print dan 'Database is geconnect!'
      if(!err)
      console.log('Database is geconnect!');
      //Als er wel een error is print dan 'Database connectie niet gelukt!'
      else
      console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
      });


      Then I tried to run the code and see if the connection with mysql worked. I typed this in the command line:



      node index.js


      This is the error message I got in the command prompt :



      error image



      Does anyone know how I can fix this error and get a connection with my mysqldatabase in nodejs ?



      Any kind of help is appreciated










      share|improve this question
















      I'm trying to connect my NodeJs application with a mysql database but its not connecting for some reason.



      I did install the mysql npm like this (typed this in commandline):



      npm install mysql


      After I installed the mysql npm I made an index.js file and in that file I tried to make the connection with my database.



      This is the code inside my index.js file to make a connection with mysql:



      //Gebruik mysql npm module voor de mysql database
      const mysql = require('mysql');

      //Geef connectie details aan
      var connection = mysql.createConnection({
      host : 'localhost',
      user : 'root',
      port : '3306',
      password : 'tombal10',
      database : 'fys'
      });


      connection.connect((err) => {
      //Als er geen error is print dan 'Database is geconnect!'
      if(!err)
      console.log('Database is geconnect!');
      //Als er wel een error is print dan 'Database connectie niet gelukt!'
      else
      console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
      });


      Then I tried to run the code and see if the connection with mysql worked. I typed this in the command line:



      node index.js


      This is the error message I got in the command prompt :



      error image



      Does anyone know how I can fix this error and get a connection with my mysqldatabase in nodejs ?



      Any kind of help is appreciated







      mysql node.js database npm database-connection






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 13 '18 at 14:35







      johnny

















      asked Nov 13 '18 at 14:18









      johnnyjohnny

      155




      155
























          1 Answer
          1






          active

          oldest

          votes


















          0














          instead of



          mysqlConnection.connect((err) => {


          use



          connection.connect((err) => {
          //Als er geen error is print dan 'Database is geconnect!'
          if(!err)
          console.log('Database is geconnect!');
          //Als er wel een error is print dan 'Database connectie niet gelukt!'
          else
          console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
          });


          [Here the is tutorials reference for the code]1



          for your mysql error



          Execute the following query in MYSQL Workbench



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



          Try connecting using node after you do so






          share|improve this answer


























          • It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

            – johnny
            Nov 13 '18 at 14:32











          • Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

            – Sayed Mohd Ali
            Nov 13 '18 at 14:34











          • Thanks my brother it works now!

            – johnny
            Nov 13 '18 at 14:42











          • Your most welcome :)

            – Sayed Mohd Ali
            Nov 14 '18 at 6:10











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53283060%2fnode-js-and-mysql-not-connecting-client-does-not-support-authentication-protoco%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          instead of



          mysqlConnection.connect((err) => {


          use



          connection.connect((err) => {
          //Als er geen error is print dan 'Database is geconnect!'
          if(!err)
          console.log('Database is geconnect!');
          //Als er wel een error is print dan 'Database connectie niet gelukt!'
          else
          console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
          });


          [Here the is tutorials reference for the code]1



          for your mysql error



          Execute the following query in MYSQL Workbench



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



          Try connecting using node after you do so






          share|improve this answer


























          • It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

            – johnny
            Nov 13 '18 at 14:32











          • Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

            – Sayed Mohd Ali
            Nov 13 '18 at 14:34











          • Thanks my brother it works now!

            – johnny
            Nov 13 '18 at 14:42











          • Your most welcome :)

            – Sayed Mohd Ali
            Nov 14 '18 at 6:10
















          0














          instead of



          mysqlConnection.connect((err) => {


          use



          connection.connect((err) => {
          //Als er geen error is print dan 'Database is geconnect!'
          if(!err)
          console.log('Database is geconnect!');
          //Als er wel een error is print dan 'Database connectie niet gelukt!'
          else
          console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
          });


          [Here the is tutorials reference for the code]1



          for your mysql error



          Execute the following query in MYSQL Workbench



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



          Try connecting using node after you do so






          share|improve this answer


























          • It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

            – johnny
            Nov 13 '18 at 14:32











          • Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

            – Sayed Mohd Ali
            Nov 13 '18 at 14:34











          • Thanks my brother it works now!

            – johnny
            Nov 13 '18 at 14:42











          • Your most welcome :)

            – Sayed Mohd Ali
            Nov 14 '18 at 6:10














          0












          0








          0







          instead of



          mysqlConnection.connect((err) => {


          use



          connection.connect((err) => {
          //Als er geen error is print dan 'Database is geconnect!'
          if(!err)
          console.log('Database is geconnect!');
          //Als er wel een error is print dan 'Database connectie niet gelukt!'
          else
          console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
          });


          [Here the is tutorials reference for the code]1



          for your mysql error



          Execute the following query in MYSQL Workbench



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



          Try connecting using node after you do so






          share|improve this answer















          instead of



          mysqlConnection.connect((err) => {


          use



          connection.connect((err) => {
          //Als er geen error is print dan 'Database is geconnect!'
          if(!err)
          console.log('Database is geconnect!');
          //Als er wel een error is print dan 'Database connectie niet gelukt!'
          else
          console.log('Database connectie niet gelukt! : '+ JSON.stringify(err, undefined,2));
          });


          [Here the is tutorials reference for the code]1



          for your mysql error



          Execute the following query in MYSQL Workbench



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



          Try connecting using node after you do so







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 13 '18 at 14:36

























          answered Nov 13 '18 at 14:27









          Sayed Mohd AliSayed Mohd Ali

          9581318




          9581318













          • It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

            – johnny
            Nov 13 '18 at 14:32











          • Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

            – Sayed Mohd Ali
            Nov 13 '18 at 14:34











          • Thanks my brother it works now!

            – johnny
            Nov 13 '18 at 14:42











          • Your most welcome :)

            – Sayed Mohd Ali
            Nov 14 '18 at 6:10



















          • It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

            – johnny
            Nov 13 '18 at 14:32











          • Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

            – Sayed Mohd Ali
            Nov 13 '18 at 14:34











          • Thanks my brother it works now!

            – johnny
            Nov 13 '18 at 14:42











          • Your most welcome :)

            – Sayed Mohd Ali
            Nov 14 '18 at 6:10

















          It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

          – johnny
          Nov 13 '18 at 14:32





          It now gives me another error: client does not support authentication protocol requested by server consider upgrading mysql client

          – johnny
          Nov 13 '18 at 14:32













          Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

          – Sayed Mohd Ali
          Nov 13 '18 at 14:34





          Execute the following query in MYSQL Workbench ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Try connecting using node after you do so

          – Sayed Mohd Ali
          Nov 13 '18 at 14:34













          Thanks my brother it works now!

          – johnny
          Nov 13 '18 at 14:42





          Thanks my brother it works now!

          – johnny
          Nov 13 '18 at 14:42













          Your most welcome :)

          – Sayed Mohd Ali
          Nov 14 '18 at 6:10





          Your most welcome :)

          – Sayed Mohd Ali
          Nov 14 '18 at 6:10


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53283060%2fnode-js-and-mysql-not-connecting-client-does-not-support-authentication-protoco%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Bressuire

          Vorschmack

          Quarantine