Node JS Mysql Connection Example

By Hardik Savani | March 25, 2021 | Category : MySql Node JS


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



Tags : MySql Node JS


Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: