title: Cannot find module mysql - error
body: <p>I have installed nodejs and mysql(also the work bench)</p>
  
  <p>I am building a server using nodejs and mysql.</p>
  
  <p>in my code I write:</p>
  
  <pre><code>var mysql = require('mysql');
  var TEST_DATABASE = 'nodejs_mysql_test';
  var TEST_TABLE = 'test';
  var client = mysql.createClient({
    user: 'root',
    password: 'root',
  });
  
  client.query('CREATE DATABASE '+TEST_DATABASE, function(err) {
    if (err &amp;&amp; err.number != mysql.ERROR_DB_CREATE_EXISTS) {
      throw err;
    }
  });
  </code></pre>
  
  <p>and the compiler gives me an error:</p>
  
  <blockquote>
    <p>Error: cannot find module 'mysql'</p>
  </blockquote>