Node Js Mysql(and Mysql2) Econnreset

i am currently trying to connect to a MySQL server on the internet using Node.Js with the mysql or the mysql2 NPM dependencies to use queries and other related stuff. the code is s

Solution 1:

you can also ref below url. error while inserting LARGE volume data in mysql by using node.js （error code: 'ECONNRESET'）

I have fixed this issue. It is caused by the default definition max_allowed_packet. Find max_allowed_packet in my.ini (C:\ProgramData\MySQL\MySQL Server 5.7). Update to 'max_allowed_packet=64M'. Restart mysql. Done.

Solution 2:

Hi I know this was asked some time ago, but is it possibly because you're using:

conn.end()

Since you're using a Pooled connection, I think you can release the connection using

conn.release()

Or

conn.destroy()