Create Connection

We can use Node.js in database applications. Here we use MySQL as a database with Node.js.

Install MySQL on your computer.

You can download it from here

Once the MySQL is installed and running, you can access it by using Node.js.

Install MySQL Driver

You have to install MySQL driver to access a MySQL database with Node.js. Download MySQl module from npm.

To download and install the "mysql" module, open the Command Terminal and execute the following:

npm install mysql
Create connection with mysql 1

Create Connection

Create a folder named "DBexample". In that folder create a js file named "connection.js" having the following code:

var mysql = require('mysql');
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "12345"
con.connect(function(err) {
  if (err) throw err;

Now open the command terminal and use the following command:

Node connection.js

Create connection with mysql 2

Now Node.js is connected with MySQL.

Related Tutorial
Follow Us #