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