Node.js MySQL Create Database

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

Example

For creating a database named “javatpoint”.

Create a js file named javatpoint.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 javatpoint", function (err, result) {  

if (err) throw err;  

console.log("Database created");  

});  

});  

Now open command terminal and run the following command:

Node javatpoint.js  

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.