Skip to content
← Back to Community
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.

Answered by heyitsmarcus [earned 5 cycles]
View Answer
Voters
Profile icon
JVides22
Profile icon
DaemonBeast
Profile icon
AdCharity
Profile icon
VedangPradhan
Profile icon
AAnonymity
Profile icon
vedprad1
Comments
hotnewtop
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.

Profile icon
leon332157

I don't think you can use this code on repl.it because a repl won't have mysql installed locally. You can use an external Mysql instead.