Node.js MySQL Create Database

by Online Tutorials Library July 14, 2022

Node.js MySQL Create Database

CREATE DATABASE statement is used to create a database in MySQL.

Example

For creating a database named “tutoraspire”.

Create a js file named tutoraspire.js having the following data in DBexample folder.

  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!”);  con.query(“CREATE DATABASE tutoraspire”, function (err, result) {  if (err) throw err;  console.log(“Database created”);  });  });  

Now open command terminal and run the following command:

Node.js create database 1

You can see the database is created.

Verification

To verify if the database is created or not, use the SHOW DATABASES command. Before this, go to initial path by using mysql-p command.

Node.js create database 2

Next TopicNode.js MySQL Create Table

Node.js MySQL Create Database

Node.js MySQL Create Database

Verification

Starting and Restarting Nginx

Change Password in Oracle

You may also like