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 https://www.mysql.com/downloads/.

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:

snippet
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:

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

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
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +