Cannot find module `mysql` node.js

Cannot find module `mysql` node.js

i am a newbie to nodejs. To connect mysql, i installed mysql on node using
the command,
npm install mysql
I didn't get any error while installing. Then i tried executing the
following code,
var mysql = require("mysql");
But it is showing the following error while im trying to execute that.
C:\node\mysql>node app.js
module.js:340
throw err;
^
Error: Cannot find module 'mysql'
at Function.Module._resolveFilename (module.js:338:15)
at Function.Module._load (module.js:280:25)
at Module.require (module.js:364:17)
at require (module.js:380:17)
at Object.<anonymous> (C:\node\mysql\app.js:1:75)
at Module._compile (module.js:456:26)
at Object.Module._extensions..js (module.js:474:10)
at Module.load (module.js:356:32)
at Function.Module._load (module.js:312:12)
at Function.Module.runMain (module.js:497:10)
I tried some suggestion like installing mysql locally using,
npm install -g mysql
But nothing works. Help please!!!