title: module export for mysql connection
body: <p>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:</p>
  
  <pre><code>var mysql = require('mysql');
  
  module.exports = function(mysql) {
    var client = mysql.createConnection({
      host: 'localhost',
      user: 'root',
      password: '12345'
    });
    return client;
  }
  </code></pre>
  
  <p>But when i try to import this file into my another *.js file, i get an error: </p>
  
  <pre><code>~/work : $ node queryInfo.js
  /Users/socomo22/work/queryInfo.js:3
  client.connect();
         ^
  TypeError: undefined is not a function
      at Object.&lt;anonymous&gt; (/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
  </code></pre>
  
  <p>Since i'm new to Node.js i'm not sure what i'm doing wrong. Please help!</p>
  
  <p>queryInfo.js // Code that requires above stated module</p>
  
  <pre><code>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();
  </code></pre>