Node.js MySQL Create Database

If your administrator provide you priviledge to create database, then you can create it yourself. To create a new Database in MySQL, CREATE DATABASE statement is used. Here is the sample code to create a new database in MySQL.

Create a file name 'createdb.js' and copy & paste this code.

var mysql = require("mysql");var con = mysql.createConnection({
   host: "hostname",
   user: "username",
   password: "password"

    if(error) {
        console.log('Error establishing connection to db');
    console.log('connection established');
    con.query("CREATE DATABASE company", function(error){
            console.log("Error in creating new database");
        console.log("Created New Database");

Open cmd and run the file as -

node createdb.js

Read more articles

General Knowledge

Learn Popular Language