Node JS Mysql Connection Example

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.

TAGS
MySql
Node JS

4.5/5.0
Last updated 08 September, 2022
By Admin

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...

Database

MySql

Node JS Mysql Connection Example

Install MySQL

server.js : Mysql Database Connection

Categories

Popular Tags