Error in MySQL library for Node.js

by

The net module required and used in the MySQL node module is a core part of Node.js itself. The error you’re getting about Net.createConnection not being a function means it’s coming up as an empty object and the error is related to one of your comment to the question:

I am testing my code within a browser.

You must run this particular module on Node.js only, you can’t run it in a web browser.

One could think a possibility would be to run your code through a packer like browserify or webpack so you can easily require('mysql') in your browser but it won’t work. The net module which is a core dependency of the mysql module will be transformed into an empty object {}.
That’s not a bug, it’s how it’s supposed to work. Browsers don’t have generic tcp implementations so it can’t be emulated. The empty object is intended to prevent require('net') from failing on modules that otherwise work in the browser.

To avoid this error, you need to run this code in a pure Node.js environment, not in a browser. A simple server could serve this purpose since this code in your client in a browser can’t work and would add a security hole as everything client-side is manipulative and as such not secure. You don’t want to expose your database on the client-side but only consumes it.

More Related Contents:

  1. How can i write in NodeJS with MongoDB the following MySQL Select?
  2. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  3. MySQL with Node.js
  4. node-mysql multiple statements in one query
  5. nodejs mysql Error: Connection lost The server closed the connection
  6. How do I do a bulk insert in mySQL using node.js
  7. Node.js can’t authenticate to MySQL 8.0
  8. node.js mysql error: ECONNREFUSED
  9. How to auto generate migrations with Sequelize CLI from Sequelize models?
  10. How to access a RowDataPacket object
  11. Retrieve last inserted id with Mysql
  12. How to pass parameters to mysql query callback in nodejs
  13. Making changes to multiple records based on change of single record with SQL
  14. node.js + mysql connection pooling
  15. connect ECONNREFUSED – node js , sql
  16. How to make join queries using Sequelize on Node.js
  17. NodeJS MySQL Dump
  18. Node.js connect to MySQL Docker container ECONNREFUSED
  19. Use promise to process MySQL return value in node.js
  20. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  21. Which ORM should I use for Node.js and MySQL? [closed]
  22. find number of rows in returned mysql result (nodejs)
  23. MySQL giving “read ECONNRESET” error after idle time on node.js server
  24. Counting associated entries with Sequelize
  25. INSERT INTO fails with node-mysql
  26. a count for each join – optimisation
  27. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  28. the MySQL service on local computer started and then stopped
  29. Rename a table in MySQL
  30. Storing images in MySQL [closed]

Leave a Comment