Connection to Database and Create a database in Node

Question

I've tried to implement this code and terminal throws error something like this stucked in it As I've applied this code but it throws the error "Access denied for user ''@'localhost' to database 'mydb'"

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "myusername",
  password: "mypassword"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  /*Create a database named "mydb":*/
  con.query("CREATE DATABASE mydb", function (err, result) {
    if (err) throw err;
    console.log("Database created");
  });
});

as I have got the Connected message on console but can't able to create database from that code — Janmesh Nayak
– Janmesh Nayak, Commented Apr 17, 2019 at 6:37
well there you go, you could move your con.query() outside — 1565986223
– 1565986223, Commented Apr 17, 2019 at 6:57

Narendra Chouhan · Accepted Answer · 2019-04-17 05:55:31Z

1

create a config folder and create a file databaseConfig.js

var mysql = require('mysql');

config = {
  host: 'localhost',
  user: 'root',
  password: '',
  database: '<DB name>'
}
var connection =mysql.createConnection(config); //added the line
connection.connect(function(err){
if (err){
   console.log('error connecting:' + err.stack);
}
   console.log('connected successfully to DB.');
});

module.exports ={
   connection : mysql.createConnection(config) 
}

create a app.js file

var express = require('express');
var cors = require('cors');
app = express(),
app.use(cors()),
port = process.env.PORT || 3001;
bodyParser = require('body-parser');
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());
var routes = require('./api/routes/routes'); //importing route
routes(app);
console.log('todo list RESTful API server started on: ' + port);
app.listen(port);

create a controller.js file

var config = require('../../databaseConfig.js');
var connection= config.connection
connection.query ('CREATE DATABASE mydb', function(error, results){
  if (results){
     console.log(results);
  }  
  else{
     console.log(error);
  }
});

answered Apr 17, 2019 at 5:55

Narendra Chouhan

2,3091 gold badge17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

1565986223 Over a year ago

This answer has nothing to do with access denied

Collectives™ on Stack Overflow

Connection to Database and Create a database in Node

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related