Skip to content
Configuring a Connection in MySQL and Node.js
Profile icon
vedprad1

Configuring a Connection in MySQL and Node.js

I am trying to use MySQL in Node.js to use databases. However, when i try to tun the program that can be accessed here, I get this error:

Process crashed with: Error: connect ECONNREFUSED 127.0.0.1:8000 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1104:14) -------------------- at Protocol._enqueue (/home/runner/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Protocol.handshake (/home/runner/node_modules/mysql/lib/protocol/Protocol.js:51:23) at Connection.connect (/home/runner/node_modules/mysql/lib/Connection.js:119:18) at evalmachine.<anonymous>:11:5 at Script.runInContext (vm.js:107:20) at Object.runInContext (vm.js:285:6) at evaluate (/run_dir/repl.js:133:14) at ReadStream.<anonymous> (/run_dir/repl.js:116:5) at ReadStream.emit (events.js:189:13) at addChunk (_stream_readable.js:284:12)

Does anyone know what I can do?

The code can be found here.

You are viewing a single comment. View All
Profile icon
heyitsmarcus

You definitely can't run a MySQL database inside of repl.it as a localhost database. I don't know if that is a possible planned feature in the future or not.

But, another great option for NodeJS and SQL, that is easy to run and use, is AlaSQL. You can find it in the package manager under alasql. You should definitely check it out! I made a repl with some simple AlaSQL code that should be very familiar to you. EDIT: AlaSQL does not actually store data. It just interprets it from a resource.

https://repl.it/@heyitsmarcus/Database-Test

Here is their website: http://alasql.org/

Here is their Github page: https://github.com/agershun/alasql

Another option for storing data is https://jsonstore.io. It's totally free, and you get easy to use JSON responses. It's good for small projects with small amounts of data. They have a great library appropriately named jsonstore.io in the package manager for working with their JSON data.

Profile icon
heyitsmarcus

@heyitsmarcus
sorry,
@vedprad1
, I accidentally used your repl link instead of mine! I edited the comment for my repl hahaha

Profile icon
Vandesm14

@heyitsmarcus
Is mySQL able to work with nodejs via polygott?

Profile icon
heyitsmarcus

@Vandesm14
There is a package for MySQL (aptly named mysql haha) that you can find in the Package manager here on repl.it. You can connect to a remote MySQL server and work with it. You just can't spin up an instance of a localhost database yet, although whether local SQL databases are a planned feature or not, I have no idea.

Profile icon
heyitsmarcus

And I made an update to the original post but I thought that AlaSQL would store the data into a server database, much the same way that WebSQL works, but that is not the case. AlaSQL just interprets and then allows you to query the data in a SQL format.