Node.js MySQL Connection

Before using Mysql in Node.js, You must install the MySQL package in your system. you can read Mysql InstallationDocumentation on the MySQL official website.

If you are working with PHP & MySQL, you need not install MySQL. Your MySQL Module will work in Node.js by just starting PHP Xampp/Wamp server.

You can use the following general script to connect Node.js with the database. To understand this script, You must read all the steps of this tutorial.

var mysql = require('mysql');
var conn = mysql.createConnection({
    host     : 'Enter your Host Name',
    user     : 'Enter your Databse username',
    password : 'Enter your Database password',
    database : 'Enter your Database Name'
});
conn.connect(function(err) {
  if (err) throw err;
  console.log('Database is connected successfully !');
});
module.exports = conn;

How to Connect Node.js with MySQL Database

Now, I am going to explain Node.js MySQL Connection step by step. So, you should go through the following steps.

Before getting started Node.js MySQL Connection, You must install Node.js or Express Application.

Also Read: How to Install Express Application

Install MySql Module

First of all, Install Mysql module in your root folder of Node.js/ expressjs through the following command.

npm install mysql

Create MySQL Database

Create MySQL Database using the following Node.js Script

var mysql = require('mysql');
var conn = mysql.createConnection({
  host: "localhost",
  user: "yourusername",
  password: "yourpassword"
});
conn.connect(function(err) {
  if (err) throw err;
  conn.query("CREATE DATABASE nodeapp", function (err, result) {
    if (err) throw err;
    console.log("Database is created successfully");
  });
});

If you are working with PHP, You need not create MySQL database connection using the above script. You can create MySQL database in localhost/PHPMyAdmin and use it for the Node.js MySQL Connection.

Create a Custom Module for Node.js MySQL Connection

Create database.js file in the root folder of Node.js App/ express and write the following script.

You must include MySQL module by using require('mysql') in the database.js file.

File Name: database.js

var mysql = require('mysql');
var conn = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'nodeapp'
});
conn.connect(function(err) {
  if (err) throw err;
  console.log('Database is connected successfully !');
});
module.exports = conn;

In the above script, The following details are given for the local server. You can replace these details with your own

Host Name – localhost
Username – root
Password –“”
Database Name – nodeapp

Now, You can include the database.js file in the other file by using require('./database.js')

Suppose that a route index.js file is placed in the routes folder and you want to write MySQL query into it. you can include database.js file by using require('../database.js') . Because database.js the file is placed in the root folder of the node.js

NEW TECH UPDATES

Search This Blog