Cannot find module `mysql` node.js

Question

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 globally using,

npm install -g mysql

But nothing works. Help please!!!

Please note my working environment,

OS: Windows7 Node version: 0.10.15 NPM version: 1.3.5

Are you running your script from the same directory you ran npm install mysql? — Morgan ARR Allen
– Morgan ARR Allen, Commented Aug 8, 2013 at 19:27
Try running npm ls from that same directory that app.js is in. This will list out the npm modules that are installed for that project. — Jaime Morales
– Jaime Morales, Commented Aug 8, 2013 at 20:02
@JaimeMorales It is showing [email protected] ── [email protected] ── [email protected] under the tree — Stranger
– Stranger, Commented Aug 8, 2013 at 20:45

Bitwise Creative · Accepted Answer · 2013-10-04 20:03:29Z

19

I just ran into 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/

answered Oct 4, 2013 at 20:03

Bitwise Creative

4,0805 gold badges31 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

moderns Over a year ago

I installed it more than one time using npm install -g mysql but I get :/usr/local/lib/node_modules/mysql# ls node_modules bignumber.js readable-stream require-all, I don't find node-mysql, please advise about the path to do the above, because it doesn't work

Ashok kumar Ganesan Over a year ago

I use the mysql2 2.2.5 version which does not have cardinal but the helper.js requires for the cardinal as below. How to solve this? Error: Can't walk dependency graph: Cannot find module 'cardinal' from '\node_modules\mysql2\lib' required by node_modules\mysql2\lib\helpers.js

Liam · Accepted Answer · 2019-03-05 15:23:27Z

16

npm install mysql --save

This will update your package.json file.

edited Mar 5, 2019 at 15:23

Liam

30k28 gold badges143 silver badges206 bronze badges

answered Sep 20, 2017 at 23:54

user991802

3613 silver badges3 bronze badges

Comments

coderz · Accepted Answer · 2015-01-27 14:31:02Z

12

My node is installed in C:\some-dir\nodejs-0.10.35\

First navigate to the same directory node installed: cd C:\some-dir\nodejs-0.10.35

Then npm install mysql

I put my applications in the same directory: C:\some-dir\nodejs-0.10.35\applications\demo.js

It works.

answered Jan 27, 2015 at 14:31

coderz

5,01912 gold badges53 silver badges80 bronze badges

1 Comment

Ashok kumar Ganesan Over a year ago

I use the mysql2 2.2.5 version which does not have cardinal but the helper.js requires for the cardinal as below. How to solve this? Error: Can't walk dependency graph: Cannot find module 'cardinal' from '\node_modules\mysql2\lib' required by node_modules\mysql2\lib\helpers.js

Morgan ARR Allen · Accepted Answer · 2013-08-08 19:29:29Z

10

It looks like you might be confused about how npm install works.

npm install -g mysql will install globally not locally like you suggest.

npm install mysql will install locally, putting the module in ./node_modules/mysql. This means the script you are running needs to be run from the same directory containing node_modules.

answered Aug 8, 2013 at 19:29

Morgan ARR Allen

10.7k3 gold badges38 silver badges33 bronze badges

Comments

Sebastian Weschke · Accepted Answer · 2014-11-02 19:47:29Z

7

You can fix this with

ln -s /usr/local/lib/node_modules /YOURPROJECTFOLDER/node_modules

edited Nov 2, 2014 at 19:47

answered Nov 2, 2014 at 18:05

Sebastian Weschke

711 silver badge3 bronze badges

2 Comments

Parasu Over a year ago

for me, this one really get past the error "Cannot find module 'mysql'"

ᴍᴇʜᴏᴠ Over a year ago

Actually, the other way around ln -s /YOURPROJECTFOLDER/node_modules /usr/local/lib/node_modules worked for me (Debian 10)

joelc · Accepted Answer · 2014-06-13 16:13:01Z

3

I was having the same issue (granted I am on Windows 8). I tried npm install mysql and npm install -g mysql and neither worked.

Turned out I needed to open the 'Node.js Command Prompt' app rather than the regular command prompt app. Everything worked great.

I don't know what their command prompt does under the hood but I would assume it has something to do with pathing and environment variables. You may want to give it a try.

answered Jun 13, 2014 at 16:13

joelc

2,8416 gold badges47 silver badges68 bronze badges

Comments

abhishek bv · Accepted Answer · 2018-02-12 18:40:13Z

2

You might have to update the package.json file. Use the following command

npm install mysql --save

answered Feb 12, 2018 at 18:40

abhishek bv

819 bronze badges

1 Comment

Liam Over a year ago

This exact same answer was added a full 5 months before you added this one.

Liam · Accepted Answer · 2019-03-05 15:29:40Z

1

I faced the same issue. Here is how solved it.

First created a proj dir e.g (Users/home/proj)
Go to then proj folder.
Run npm init (this will create packaje.json).
Run (npm install mysql)
Check in proj folder, you should see node_modules folder, expand node_modules and you should see mysql folder.
Run your app.js

edited Mar 5, 2019 at 15:29

Liam

30k28 gold badges143 silver badges206 bronze badges

answered Nov 10, 2018 at 1:03

Atul Kumar

811 silver badge1 bronze badge

Comments

Maximilian Ast · Accepted Answer · 2019-12-16 10:28:19Z

1

npm install mysql2 --save

and require this one

var mysql = require("mysql2");

edited Dec 16, 2019 at 10:28

Maximilian Ast

3,50712 gold badges39 silver badges51 bronze badges

answered Dec 16, 2019 at 6:20

Miniyahil Kebede

213 bronze badges

Comments

harshvardhan · Accepted Answer · 2016-03-01 14:37:54Z

0

Navigate to folder /node_modules which is inside the main directory, and install mysql by hitting the following command: sudo npm install mysql

This will create a folder called mysql inside the /node_modules folder.

Now run your app using node app.js command inside the main folder. It shall work and establish the connection with mysal server.

answered Mar 1, 2016 at 14:37

harshvardhan

80515 silver badges32 bronze badges

Comments

hoogw · Accepted Answer · 2018-07-05 21:18:44Z

0

I have same error, just run

npm install

will fix the problem. Sometime due to some reason, mysql package was damaged, or deleted, or missing, just run above will fix everything.

answered Jul 5, 2018 at 21:18

hoogw

5,6071 gold badge46 silver badges37 bronze badges

Comments

cakan · Accepted Answer · 2018-10-09 11:05:19Z

0

I noticed that on npm install -g mysql has saved mysql2 in node_modules. Just changed

require('mysql')

to

require('mysql2')

and it worked.

edited Oct 9, 2018 at 11:05

cakan

2,1175 gold badges33 silver badges45 bronze badges

answered Oct 9, 2018 at 10:10

Salman lodi

264 bronze badges

Comments

Arjon Arts · Accepted Answer · 2018-11-12 11:16:35Z

0

This worked for me

go to your project folder
run the following command: npm install mysql

answered Nov 12, 2018 at 11:16

Arjon Arts

394 bronze badges

Comments

Rohit Soni · Accepted Answer · 2019-12-19 05:42:50Z

0

npm install MySQL --save

This is because you have not install MySQL in your package. You are importing this without installing MySQL in your system environment

answered Dec 19, 2019 at 5:42

Rohit Soni

551 gold badge1 silver badge7 bronze badges

Comments

Feng Zhang · Accepted Answer · 2021-01-23 02:28:13Z

0

if using package.json, simply add below and run "npm install" in your project.

{ "dependencies": { "mysql": "2.12.0" } }

answered Jan 23, 2021 at 2:28

Feng Zhang

2,0001 gold badge21 silver badges22 bronze badges

Comments

jwood · Accepted Answer · 2017-01-06 18:26:35Z

-1

I have found this happens if you run npm install without having dependencies defined in your package.json ... i.e.

...
"author": "Author",
"dependencies" : {
     "mysql": "2.12.0",    
},
"license": "ISC"
...

Define the dependecies .. then run

npm install

answered Jan 6, 2017 at 18:26

jwood

3732 silver badges6 bronze badges

1 Comment

Liam Over a year ago

npm install mysql --save will add this dependency for you without you having to edit the file manually

Collectives™ on Stack Overflow

Cannot find module `mysql` node.js

16 Answers 16

2 Comments

Comments

1 Comment

Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

16 Answers 16

2 Comments

Comments

1 Comment

Comments

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related