Node.js MySQL Create Database

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

Example

For creating a database named “”.

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

Current Time 0:05

/

Duration 18:10

Loaded: 4.04%

 Fullscreen

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 codeworld.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.