Node.js MySQL Create Database

In this article, we will see Node.js MySQL Create Database. For any kind data store or run query then we need database like MySQL, MongoDB, PostgreSQL but one of the most popular databases is MySQL. You can create database in MySQL using Node.js using the mysql module or connect MySQL with node.js.

So, let's see how to create a database in node js or node js MySQL connection.

You can download MySQL database : https://www.mysql.com/downloads/.

Step 1: Install MySQL Driver

First you have to need MySQL running on your computer, you can access it by using Node.js.

To access a MySQL database with Node.js, you need a MySQL driver. now we will use the "mysql" module, downloaded from NPM.

 

 

To download and install the "mysql" module in an application using the below command.

npm install mysql

Now, you have to download and install a mysql database driver.

Node.js can use this module to manipulate the MySQL database.

var mysql = require('mysql');

 

Step 2: Connect Database

Create the db_connection.js file your application. and add the below code in that file.

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "your_username",
  password: "your_password"
});

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

 

Step 3: Create Database with Connection

Create a database in MySQL, use the "CREATE DATABASE" statement. So, copy below code and paste in your file.

 

 

Database Name : node_mysql_demo

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "your_username",
  password: "your_password"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected..!!");
  con.query("CREATE DATABASE node_mysql_demo", function (err, result) {
    if (err) throw err;
    console.log("Database Created..!!");
  });
});

 

Step 4 : Run db_connection.js file

Run db_connection.js using the below code.

node db_connection.js

 


You might also like:

RECOMMENDED POSTS

FEATURE POSTS