NodeJS MySQL Create Database

Last Updated : 09 Feb, 2021

Introduction:

We are going to see how to create and use mysql database in nodejs. We are going to do this with the help of CREATE DATABASE query.

Syntax:

Create Database Query: CREATE DATABASE gfg_db; Use Database Query: USE gfg_db

Modules:

NodeJs
ExpressJs
MySql

Setting up environment and Execution:

Create Project
```
npm init
```
Install Modules
```
npm install express npm install mysql
```

Create and export mysql connection object.

sqlConnection.js

const mysql = require("mysql"); let db_con = mysql.createConnection({  host: "localhost",  user: "root",  password: '' }); db_con.connect((err) => {  if (err) {  console.log("Database Connection Failed !!!", err);  } else {  console.log("connected to Database");  } }); module.exports = db_con;

Create Server:

index.js

const express = require("express"); const database = require('./sqlConnection'); const app = express(); app.listen(5000, () => {  console.log(`Server is up and running on 5000 ...`); });

Create Route to Create Database and use it.

JavaScript

app.get("/createDatabase", (req, res) => {  let databaseName = "gfg_db";  let createQuery = `CREATE DATABASE ${databaseName}`;  // use the query to create a Database.  database.query(createQuery, (err) => {  if(err) throw err;  console.log("Database Created Successfully !");  let useQuery = `USE ${databaseName}`;  database.query(useQuery, (error) => {  if(error) throw error;  console.log("Using Database");    return res.send( `Created and Using ${databaseName} Database`);  })  }); });