TypeError: Cannot read properties of undefined (reading 'createPool')

[0xMALVEE]

TypeError: Cannot read properties of undefined (reading 'createPool')

[0xMALVEE]

@0xMALVEE, thanks to show your solution 🙋🏻‍♂️

Just bringing it from MySQL2 documentation for TypeScript:

node-mysql2/website/docs/documentation/typescript-examples.mdx

Lines 21 to 37 in db13468

	## Usage
	You can import **MySQL2** in two ways:
	- By setting the `esModuleInterop` option to `true` in `tsconfig.json`
	```ts
	import mysql from 'mysql2';
	import mysql from 'mysql2/promise';
	```
	- By setting the `esModuleInterop` option to `false` in `tsconfig.json`
	```ts
	import * as mysql from 'mysql2';
	import * as mysql from 'mysql2/promise';
	```

@wellwelwel thanks. I didn't knew that tsconfig property exists haha. 🤯

[0xMALVEE]

idk why mysql2 is saying it's undefined. I rm -r node_modules and install again same thing.

[0xMALVEE]

@sidorares @wellwelwel @jmordica

[wellwelwel]

Hey @0xMALVEE, can you share a basic repro as text/code block?

Knowing more about your context can help (some practical usage for databaseProvider and useFactory or where they are called, for example) 🙋🏻‍♂️

[0xMALVEE]

Hey @0xMALVEE, can you share a basic repro as text/code block?

Knowing more about your context can help (some practical usage for databaseProvider and useFactory or where they are called, for example) 🙋🏻‍♂️

Basically a nest js mono repo. it only doing problem with mysql2 , all other npm packages work just fine. Even I put it on main.ts same giving undefined other then useFactory.

[wellwelwel]

When isolating NestJS and MySQL2, do you get the same error? If so, please share it. With a repro, I can get the same error to test it.

Sorry @0xMALVEE, I can't reproduce your code as an image 😕

[0xMALVEE]

When isolating NestJS and MySQL2, do you get the same error? If so, please share it. With a repro, I can get the same error to test it.

Sorry @0xMALVEE, I can't reproduce your code as an image 😕

aight let me prepair for you.

[0xMALVEE]

@wellwelwel hey I posted in nest js discord as well. just checked seems like they gave a solution , was a problem with my import. it's working now. had to import * as . but in drizzle docs they didn't mention this seems out outdated drizzle docs.

[0xMALVEE]

import problem. drizzle docs outdated.

[wellwelwel]

@0xMALVEE, thanks to show your solution 🙋🏻‍♂️

---

Just bringing it from MySQL2 documentation for TypeScript:

node-mysql2/website/docs/documentation/typescript-examples.mdx

Lines 21 to 37 in db13468

	## Usage
	You can import **MySQL2** in two ways:
	- By setting the `esModuleInterop` option to `true` in `tsconfig.json`
	```ts
	import mysql from 'mysql2';
	import mysql from 'mysql2/promise';
	```
	- By setting the `esModuleInterop` option to `false` in `tsconfig.json`
	```ts
	import * as mysql from 'mysql2';
	import * as mysql from 'mysql2/promise';
	```