Nodejs change db connection run time

Question

I need to change Nodejs MySQL database connection at runtime.

Here is my code,

var mysql=require('mysql'); 
var connection = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'test' }); 
var connection2 = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'test1' }); 
connection.connect(function(err) { if (err) throw err; console.log('You are now connected...'); }); connection2.connect(function(err) { if (err) throw err; console.log('You are now connected...'); });

Do you have any idea about it?

Please share with me.

Thanks.

yes please see.. var mysql=require('mysql'); var connection = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'test' }); var connection2 = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'test1' }); connection.connect(function(err) { if (err) throw err; console.log('You are now connected...'); }); connection2.connect(function(err) { if (err) throw err; console.log('You are now connected...'); }); — Shubham Azad
– Shubham Azad, Commented Apr 11, 2018 at 7:22
When I select the drop down option, then my DB connection should be changed. — Shubham Azad
– Shubham Azad, Commented Apr 11, 2018 at 7:28

Sravan · Accepted Answer · 2018-04-11 10:39:16Z

1

MySQL offers a changeUser command that allows you to alter the current user and other aspects of the connection without shutting down the underlying socket:

Since you exported connection using module exports, you can require that as below

var connection = require('./connection.js');

var connection = require('./connection.js'); // your path

function changeConnection(db)

   connection.changeUser({database : 'my_database'}, function(err) { 
     if (err) throw err; 
   });
}

Here is the documentation for the same

edited Apr 11, 2018 at 10:39

answered Apr 11, 2018 at 7:38

Sravan

18.7k3 gold badges33 silver badges54 bronze badges

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

15 Comments

Shubham Azad Over a year ago

Actually, I created a separate connection file and require it's in my model so I am not understanding how can I changed my connection, and require it to in my all models files

Sravan Over a year ago

means? I didnt get you

Shubham Azad Over a year ago

Please see in the question I have uploaded a picture.

Sravan Over a year ago

picture? Where is it?

Sravan Over a year ago

okay you can just require that connection using the file name

|

Thavaprakash Swaminathan · Accepted Answer · 2018-04-11 08:22:18Z

0

Please try this, I hope it will serve the purpose.

var mysql=require('mysql'); 

function getConnection(db){
        var connection = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : db }); 
        connection.connect(function(err) { 
            if (err) throw err; 
            console.log('You are now connected...'); 
            return connection;
        });
}


var connection = getConnection(req.param.db); //req.param.db is a user input

// Here your code goes

answered Apr 11, 2018 at 8:22

Thavaprakash Swaminathan

7,1242 gold badges32 silver badges31 bronze badges

Comments

Ander Biguri · Accepted Answer · 2018-04-11 11:13:02Z

0

Not Need to change db connection only change database name

connection.changeUser({database : 'my_database'}, function(err) {
  if (err) throw err;
});

edited Apr 11, 2018 at 11:13

Ander Biguri

35.7k12 gold badges77 silver badges125 bronze badges

answered Apr 11, 2018 at 10:39

Shubham Azad

7962 gold badges11 silver badges25 bronze badges

Collectives™ on Stack Overflow

Nodejs change db connection run time

3 Answers 3

15 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

15 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related