Cannot find module `mysql` node.js

Question

I am very new to node js. To connect mysql, I have installed mysql on node using the command,

npm install mysql

I didn't get any error while installing. Then I have tried executing the below code,

var mysql = require("mysql");

But it is giving the below error while I'm trying to run 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 have also tried some suggestions like installing MySQL globally using,

npm install -g mysql

But nothing is working. can anyone help with this?

Please note my working environment,

Operating System: Windows 7 Node version: 0.10.15 NPM version: 1.3.5

Answer 1

I was having the same problem and found it was because the module was installed in:

./node_modules/node-mysql/node_modules/

So, I just moved them all:

mv ./node_modules/node-mysql/node_modules/* ./node_modules/

Discover the Power of Node.JS Express Framework: Start Building Dynamic Web Applications Today!

Join the SQL Certification course if you want to gain more knowledge in SQL.