Canno't find mysql module - error

Question

I installed nodejs and mysql (also desktop)

I am creating a server using nodejs and mysql.

in my code I write:

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 && err.number != mysql.ERROR_DB_CREATE_EXISTS) { throw err; } }); 

and the compiler gives me an error: Error: cannot find module 'mysql'

any ideas?

Thank you

Answer 1

I think I solved it.

there is a node_modules folder in the nodejs folder in this folder there is a mysql folder. copied it to the folder from which I run my program, and I t work :)

Answer 2

This happens when you do not have a module installed, so go to the root of your project and install node -mysql:

 npm install mysql 

You do not need to manually copy the folder yourself, and dependencies are best handled using NPM.

Answer 3

• Go to the project folder .... in my case
• enter as shown in screenshot

npm install mysql

3. After installation, you will see the following directories.