type error in v3.1.0

[sdg9670]

I couldn't find connection.promise()

mysql.createConnection().promise()

[fated-x]

I too am experiencing this issue. The root cause appears to be the fact that /node_modules/mysql2/typings/mysql/lib/Pool.d.ts declared Pool class has a promise property that returns an any type:

Line 74: promise(promiseImpl?: any): any;

My Temporary Workaround (Solution):

1. Revert the mysql2 dependency back to version 2.3.3. The pool.promise() in this version is typed in /node_modules/mysql2/index.d.ts on line 151 and will work as expected because it returns a PromisePool:

promise(promiseImpl?: PromiseConstructor): PromisePool;

[anders8]

I originally experienced a similar issue with 3.0.0 and like @fated-x I reverted, to the 2.2.5 I was using in my case. I just tried 3.2.0 and it's compiling without errors and making connections without apparent trouble.

However, I'm using mysql.createPool() not mysql.createConnection()

[marcellino-ornelas]

Im using 3.2.0 and im getting a error when trying to use promise on connection

Property 'promise' does not exist on type 'Connection'.ts(2339)

import { createConnection, Connection } from 'mysql2';
import { config } from '@src/config';

export const db: Connection = createConnection(config.db);

db.promise(); // <---- error

[tristan-nsg]

I'm still getting this issue on 3.3.0

[wellwelwel]

@tristan-nsg

Look at this fix:

• fix: Missing types in "mysql" import #1995

This PR changes are relatively extensive (especially the automated tests to prevent new changes from breaking the typings again), so this review cannot be rushed 🙋🏻‍♂️

[wellwelwel]

@sdg9670, sorry for the delay, this issue has been fixed in version 3.3.1.

Can you check it again in ^3.4.0?

[wellwelwel]

After version ^3.3.5, you can follow this example:

node-mysql2/test/tsc-build/mysql/createConnection/promise/execute.ts

Lines 5 to 11 in 00508c3

	const db = mysql.createConnection(access).promise();
	{
	/** Overload: execute(sql) */
	const [results, fields] = await db.execute(sql);
	console.log(results, fields);
	}

---

I'm closing this Issue, but feel free to ask anything 🙋🏻‍♂️