Menu Close

Connecting to the MySQL database using NodeJs

codeamend

Install MySQL NPM package

Open the comment prompt and go to directory and run comment

C:\>npm install mysql 

Then create the database connection with nodejs using below code.

//mysql.js
var mysql = require('mysql');

var connection=mysql.createConnection({
   host:'localhost',
   user:'username',
   password:'password',
   database:'dbname',
   port:3306
});

connection.connect(function(err) {
  if (err) throw err;
  console.log("Database Connected!");
}); 

Then run the node comment to check the result

C:\>node mysql.js

Output will be: Database Connected! 

View More Details about the MySQL package – https://www.npmjs.com/package/mysql

Posted in NodeJs, NPM

You can also read...

Leave a Reply

Your email address will not be published.