I've been playing with Node.js and i was writing some test applications with node-mysql. I am trying to write a module that automatically establishes connections with the database so that i don't have to write the code for connection again and again. Here is what i have written:

var mysql = require('mysql');



module.exports = function(mysql) {

  var client = mysql.createConnection({

    host: 'localhost',

    user: 'root',

    password: '12345'

  });

  return client;

}

But when i try to import this file into my another *.js file, i get an error:

~/work : $ node queryInfo.js

/Users/socomo22/work/queryInfo.js:3

client.connect();

       ^

TypeError: undefined is not a function

    at Object.<anonymous> (/Users/socomo22/work/queryInfo.js:3:8)

    at Module._compile (module.js:460:26)

    at Object.Module._extensions..js (module.js:478:10)

    at Module.load (module.js:355:32)

    at Function.Module._load (module.js:310:12)

    at Function.Module.runMain (module.js:501:10)

    at startup (node.js:129:16)

    at node.js:814:3

Since i'm new to Node.js i'm not sure what i'm doing wrong. Please help!

queryInfo.js // Code that requires above stated module

var client = require('./connectMysql');



client.query(USE node);



client.query(INSERT INTO test(content) VALUES(?), ['the content'],

  function(err, info) {

    if(err)

      return handle_error(err);

    console.log(info.insertId);

});





client.query('UPDATE test SET content = ?', ['new content'], function(err, info) {

  if(err)

    return handle_error(err);

  console.log(info.insertId);

});



client.end();