Node.js MySQL Create Database

Websolutionstuff | Sep-22-2021 | Categories : MySQL Node.js

In this tutorial 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.

we can create database in MySQL using Node.js in using mysql module or connect MySQL with node.js.

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

Step 1 : Install MySQL Driver

First you have to need MySQL and 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 application using below command.

npm install mysql

Now you have downloaded and installed a mysql database driver.

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

var mysql = require('mysql');

 

Step 2 : Connect Database

Create db_connection.js file your application. and copy 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 below code :

node db_connection.js

 


You might also like :

Recommended Post
Featured Post
CRUD With Image Upload In Laravel 10 Example
CRUD With Image Upload In Lara...

In this article, we will see crud with image upload in laravel 10 examples. Here, we will learn how to image upload with...

Read More

Mar-27-2023

How To Generate Barcode Using Javascript
How To Generate Barcode Using...

In this article, we will see how to generate barcode using javascript. We will use a javascript plugin to generate...

Read More

Nov-01-2022

How to Get Random Record in Laravel 10
How to Get Random Record in La...

Here you will learn how to get random records from DB in laravel using the inRandomOrder() method. Explore an...

Read More

Nov-10-2023

Laravel tips: DB Models and Eloquent - 2023
Laravel tips: DB Models and El...

Welcome to the fourth installment of our "Laravel Tips: DB Models and Eloquent" series. In this article, we co...

Read More

Oct-18-2023