ItSolutionStuff.com

Hello,

This is a short guide on node js mysql connection example. you will learn how to connect mysql database in node js. we will help you to give example of how to use mysql in node js. step by step explain mysql connection in node js.

In this example, i will give you simple example of how to connect mysql database using node js. i am not going to explain you in more details, but give you simple example, so let's see example.

Install MySQL

you have to install mysql using bellow npm command:

npm install mysql

server.js : Mysql Database Connection

var mysql = require('mysql');  
  
var connection = mysql.createConnection({  
  host: "localhost",  
  database : 'laravel8_blog',
  user: "root",  
  password: "root"  
});  
  
connection.connect(function(err) {  
  if (err) throw err;  
  console.log("Connected!");  
});  
  
connection.query('SELECT * FROM events', function (error, results, fields) {
    if (error)
        throw error;
  
    results.forEach(result => {
        console.log(result);
    });
});
  
connection.end();

now you can run project by following command:

node server.js

you will see layout as like bellow:

I hope it can help you...