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/.
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');
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..!!");
});
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..!!");
});
});
run db_connection.js using below code :
node db_connection.js
You might also like :
In this article, we will see laravel 9 socialite login with twitter account. Many websites provide different t...
Nov-12-2022
This article will show the laravel 8 google pie chart example. Google charts use to visualize data on you...
Mar-03-2021
Hello, Laravel developers! In this article, I'll show you how to easily import and export CSV and Excel files in Lar...
Sep-13-2024
This article will show us how to validate upload file type using javascript. Using this post we can easily check the sel...
Aug-03-2020