Myujth

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

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