Attribute "promise" does not exist on type "Connection"

[tomoat]

Attribute "promise" does not exist on type "Connection"

import mysql from 'mysql2'
import util from 'util'

const conn = mysql.createConnection({
host: '127.0.0.1',
user: 'root',
password: '12345678',
port: 3306,
database: 'domain',
rowsAsArray: true,
})

const db = conn.promise() // This line reported an error
export { db }

[gtavos]

Even from mysql2/promise the promise() option is not available in Connection class. Is it available in 3.2.0 or lower versions?

[sidorares]

Looks like #1949 should fix the issue

[newtoncodes]

Doesn't seem right.
Here is the code: https://github.com/sidorares/node-mysql2/blob/master/lib/connection.js#L155
It should not return a promise. All my implementations require createConnection and .promise() to directly return a connection instance. Seems like the code is right, but the typings are wrong in the new version as well.

[wellwelwel]

@tomoat, can you try it in version ^3.3.5?

[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 🙋🏻‍♂️