Error cannot find module mysql

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:nodemysql>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:nodemysqlapp.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

While I blogged about how to setup Node.js and MySQL almost two years ago, it was interesting when a student ran into a problem. The student said they’d configured the environment but were unable to use Node.js to access MySQL.

The error is caused by this import statement:

const mysql = require('mysql')

The student got the following error, which simply says that they hadn’t installed the Node.js package for MySQL driver.

internal/modules/cjs/loader.js:638
    throw err;
    ^
 
Error: Cannot find module 'mysql'
    at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)
    at Function.Module._load (internal/modules/cjs/loader.js:562:25)
    at Module.require (internal/modules/cjs/loader.js:692:17)
    at require (internal/modules/cjs/helpers.js:25:18)
    at Object.<anonymous> (/home/student/Data/cit325/oracle-s/lib/Oracle12cPLSQLCode/Introduction/query.js:4:15)
    at Module._compile (internal/modules/cjs/loader.js:778:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
    at Module.load (internal/modules/cjs/loader.js:653:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
    at Function.Module._load (internal/modules/cjs/loader.js:585:3)

I explained they could fix the problem with the following two Node.js Package Manager (NPM) commands:

npm init --y 
npm install --save mysql

The student was able to retest the code with success. The issue was simply that the Node.js couldn’t find the NPM MySQL module.

Не удается найти модуль `mysql` node.js

Я новичок в nodejs. Чтобы подключить mysql, я установил mysql на узле с помощью команды

У меня не было ошибок при установке. Затем я попытался выполнить следующий код,

Но при попытке выполнить это показывает следующую ошибку.

Я попробовал какое-то предложение, например, установить mysql по всему миру, используя,

Но ничего не работает. Помоги пожалуйста.

Обратите внимание на мою рабочую среду,

ОС: Windows7 Версия узла: 0.10.15 Версия NPM: 1.3.5

16 ответов

Я столкнулся с той же проблемой и обнаружил, что это связано с тем, что модуль был установлен в:

Итак, я просто переместил их все:

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

Мой node установлен в C:some-dirnodejs-0.10.35

Сначала перейдите в тот же каталог node установлен: cd C:some-dirnodejs-0.10.35

Тогда npm install mysql

Я помещаю свои приложения в тот же каталог: C:some-dirnodejs-0.10.35applicationsdemo.js

Похоже, вы не понимаете, как работает npm install .

npm install -g mysql будет устанавливаться глобально, а не локально, как вы предлагаете.

npm install mysql будет установлен локально, поместив модуль в ./node_modules/mysql . Это означает, что сценарий, который вы выполняете, необходимо запускать из того же каталога, в котором находится node_modules .

Это обновит ваш файл package.json.

Вы можете исправить это с помощью

У меня была такая же проблема (если я использую Windows 8). Я пробовал npm install mysql и npm install -g mysql , но ни один из них не работал.

Оказалось, что мне нужно было открыть приложение «Командная строка Node.js», а не обычное приложение командной строки. Все отлично работало.

Я не знаю, что делает их командная строка под капотом, но я предполагаю, что это как-то связано с путями и переменными среды. Вы можете попробовать.

Источник

Error: Cannot find module ‘promise-mysql’ #419

Run code commit 4b53 get error on docker ubuntu16.04

Does this mean mysql is not installing ?
use dpkg -l will get
pooldaemon@1d365fbdeafb:

$ dpkg -l | mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Thanks for your advance .

The text was updated successfully, but these errors were encountered:

Lack of dependencies , in general , lack of “npm install” , I don’t know docker.

@bobbieltd
in this script https://raw.githubusercontent.com/Snipa22/nodejs-pool/master/deployment/deploy.bash
will install nvm and npm from line 41

I’m curious about if install mysql-server before run script will success install like this :

not install mysql-server befort run script will get error :

The bash installation will install mysql-server in this line :
sudo DEBIAN_FRONTEND=noninteractive apt-get -y install git python-virtualenv python3-virtualenv curl ntp build-essential screen cmake pkg-config libboost-all-dev libevent-dev libunbound-dev libminiupnpc-dev libunwind8-dev liblzma-dev libldns-dev libexpat1-dev libgtest-dev mysql-server lmdb-utils libzmq3-dev

promise-mysql is a dependency in package.json (install by npm install)

You can Google how to install promise-mysql (perhaps other dependencies also) for docker. I guess it is unrelated to mysql-server.

I fixed this issue with

in nodejs-pool folder

© 2023 GitHub, Inc.

You can’t perform that action at this time.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.

Источник

ES Modules does not work with namespaced library #27408

I’m using experimental-modules since v8. I tried to use «type»: «module» in v12 and it’s fine except for namespaced library (uuid, lodash, . )

This kind of imports:

Causes this error:

The text was updated successfully, but these errors were encountered:

the modules implementation currently disables extension resolution. you’ll need to use —es-module-specifier-resolution=node to get the good behaviour or go into the lodash and uuid folders and check what the extensions of those files are and add that to the import.

Closing as answered.

Had this same issue, @devsnek solution worked, thanks!

this is sort of an ongoing feedback thing for modules team so i’m gonna re-open it

@aadamsx how are you using lodash-es + experimental-modules flag on node?

This node —experimental-modules —experimental-json-modules —es-module-specifier-resolution=node index.js does not work for me with the following code:

Currently only the “default export” is supported for CommonJS files or packages

Is node or the modules loader able to see that the file is exported via module.exports ? If so, would it not be possible to export the hole object as default and every object entry as named export?
eg.

no, we have to declare the export names before evaluation, so we don’t know what module.exports looks like.

Have the same issue. And then when I use —es-module-specifier-resolution=node it breaks CommonJS modules in the namespaced library project SyntaxError: The requested module ‘date-fns’ does not provide an export named ‘format’

Have the same issue. And then when I use —es-module-specifier-resolution=node it breaks CommonJS modules in the namespaced library project SyntaxError: The requested module ‘date-fns’ does not provide an export named ‘format’

Have same issue with date-fns. Try using this syntax, works for me:
import format from ‘date-fns/format’

@ench0 @TrevTheDev be careful: import format from ‘date-fns/format’ works only because the format.js file is not importing other files, otherwise death ☠️ .

Try to import a lodash-es/whatever , or also a date-fns/whatever which imports other modules in the same library.

@ench0 @TrevTheDev be careful: import format from ‘date-fns/format’ works only because the format.js file is not importing other files, otherwise death ☠️ .

Try to import a lodash-es/whatever , or also a date-fns/whatever which imports other modules in the same library.

Tried, this is my full list of imports, no issues at all:

@ench0 if you are using typescript (without explicitly configuring es6 modules transpiling) then your using commonjs aka require.

Test is easy as creating a folder with the following:

First import dies with:

Second import dies with:

The actual path is date-fns/addDays/index.js here.

These lookups are not enabled for ES modules.

Closing as this is by design.

Help ensuring this is better explained in the documentation would be very welcome as it is a very common issue.

@guybedford, I’m trying to convert my project from CommonJS (CJS) to ES Module (MJS), to do that I use:

But then I get an error:

Error [ERR_MODULE_NOT_FOUND]: Cannot find module ‘C:UsersUserIdeaProjects…node_modulesmysql2promise’ imported from…

Источник

Error cannot find module mysql2 promise

Node MySQL 2

MySQL client for Node.js with focus on performance. Supports prepared statements, non-utf8 encodings, binary log protocol, compression, ssl much more

Table of contents

History and Why MySQL2

MySQL2 project is a continuation of MySQL-Native. Protocol parser code was rewritten from scratch and api changed to match popular mysqljs/mysql. MySQL2 team is working together with mysqljs/mysql team to factor out shared code and move it under mysqljs organisation.

MySQL2 is mostly API compatible with mysqljs and supports majority of features. MySQL2 also offers these additional features

Installation

MySQL2 is free from native bindings and can be installed on Linux, Mac OS or Windows without any issues.

First Query

Using Prepared Statements

With MySQL2 you also get the prepared statements. With prepared statements MySQL doesn’t have to prepare plan for same query everytime, this results in better performance. If you don’t know why they are important, please check these discussions

MySQL provides execute helper which will prepare and query the statement. You can also manually prepare / unprepare statement with prepare / unprepare methods.

Using connection pools

Connection pools help reduce the time spent connecting to the MySQL server by reusing a previous connection, leaving them open instead of closing when you are done with them.

This improves the latency of queries as you avoid all of the overhead that comes with establishing a new connection.

The pool does not create all connections upfront but creates them on demand until the connection limit is reached.

You can use the pool in the same way as connections (using pool.query() and pool.execute() ):

Alternatively, there is also the possibility of manually acquiring a connection from the pool and returning it later:

Using Promise Wrapper

MySQL2 also support Promise API. Which works very well with ES7 async await.

MySQL2 use default Promise object available in scope. But you can choose which Promise implementation you want to use

MySQL2 also exposes a .promise() function on Pools, so you can create a promise/non-promise connections from the same pool

MySQL2 exposes a .promise() function on Connections, to «upgrade» an existing non-promise connection to use promise

Array results

If you have two columns with the same name, you might want to get results as an array rather than an object to prevent them from clashing. This is a deviation from the Node MySQL library.

For example: select 1 as foo, 2 as foo .

You can enable this setting at either the connection level (applies to all queries), or at the query level (applies only to that specific query).

Connection Option

Query Option

API and Configuration

MySQL2 is mostly API compatible with Node MySQL. You should check their API documentation to see all available API options.

One known incompatibility is that DECIMAL values are returned as strings whereas in Node MySQL they are returned as numbers. This includes the result of SUM() and AVG() functions when applied to INTEGER arguments. This is done deliberately to avoid loss of precision — see https://github.com/sidorares/node-mysql2/issues/935.

If you find any other incompatibility with Node MySQL, Please report via Issue tracker. We will fix reported incompatibility on priority basis.

Documentation

You can find more detailed documentation here. You should also check various code examples to understand advanced concepts.

Источник

How to solve «Error: Cannot find module ‘*.js’» with Node.js

Introduction

If you are trying to run your Node.js application and you get something like this:

then you are most likely trying to run the wrong file. It is possible you are missing a dependency that is needed from npm install , but if it says it cannot find the main file you are trying to run, then you are trying to run a file that does not exist. It is a common mistake.

How to fix «Error: Cannot find module»

You need to double check you are running the correct file from the correct directory. Here are some steps to diagnose.

General tips

Here are some general things to keep in mind when diagnosing the issue:

• Make sure you are in the correct directory.
• Make sure you are trying to run the correct file name.
• File and directory names are case sensitive.

How to change directories

To change directories, use the cd command in your terminal. For example, if your username was Me on the computer:

How to see what directory you are in

To check what directory you are currently in, use the folowing in your terminal.

How to print the contents of current directory

To see what files and directories exist in your current directory use the following in your terminal:

Conclusion

After reading this you should have some idea why you get the error Error: Cannot find module and how to diagnose and fix the problem.

Источник

used: < npm update mysql > | < npm -g update mysql > and < npm update -g mysql >

console.log("step 0");

var mysql = require('mysql');

var mysqlc = mysql.createConnection({
    host:'localhost',// host of server
    user:'root',// MySQL user
    password:'',// MySQL password
    database:'rage_bados'// MySQL database
});

mysqlc.connect(function(e) {
if(e) {
	console.log("Error connecting to the database with error "+e);
}
else {
	console.log('Database connected!')
}
});

mysqlc.end();

mysqlc.query("SELECT * FROM `users` WHERE `nickname`=", [], function(e, r) {
if(e) {
console.log('Error on connection ... ');
throw e;
}
else {
console.log('Password is '+r[0].passcode);
}
});

ERROR:

step 0
Error: Error: Cannot find module 'mysql'
    at Function.Module._resolveFilename (internal/modules/cjs/loader.js:581:15)
    at Function.Module._load (internal/modules/cjs/loader.js:507:25)
    at Module.require (internal/modules/cjs/loader.js:637:17)
    at require (internal/modules/cjs/helpers.js:20:18)
    at Object.<anonymous> (D:RAGEMPserver-filespackagesfreeroamindex.js:15:13)
    at Module._compile (internal/modules/cjs/loader.js:689:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10)
    at Module.load (internal/modules/cjs/loader.js:599:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
    at Function.Module._load (internal/modules/cjs/loader.js:530:3)

Edited August 4, 2019 by el9in