How do u use MySQL?
This isn't working, and I don't exactly know why. Please help. Thanks you!
I made a tutorial to learn about this in learn https://repl.it/talk/learn/Create-Account-Database-MySQL-nodejs/20263
sadly, MySQL is not compatible with SQLite
Aight, @LiamDonohue
also, I have a question. what's not working. there is no project in this post @RohilPatel
I don't think mysql works on repl.it. Last time I checked, only sqlite3 works on repl.it
Line 21
:
console.log("An error occured")
What good person would do this to themselves?
console.log("An error occured", error)
And you will see the error.
Or go to line 15
and fill it out.
how is this not a connection. look at the error. @Coder100
Why would you not put in a password. @RohilPatel
do I need to make one?
@Coder100
well duh... if you think about it... what is the point of accounts? To identify who's database is who's duh @RohilPatel
A connection error means it has connected to the wrong initials I bet the URLs are based on your username and password or the connection refused because your username and password is incorrect *facepalm* @RohilPatel
Im so confused 😐 @Coder100
on what? @RohilPatel
Everything. @Coder100
I think it’s mssqul?
Edit: oops. msql. that.
What? I'm confused now.... @Giothecoder
@RohilPatel require('msql); instead of mysql
@RohilPatel or do you mean you don’t know how to make a statement?
Im trying it. @Giothecoder
Nope. More errors. @Giothecoder
Idk how to connect it. @Giothecoder
@RohilPatel oohhh. Wait but there’s probably stuff about that on the docs. Go look for msql on npm.org, and it should be there maybe?
I have tried, but you need to install something, and that won't work with repl. @Giothecoder
@RohilPatel what do you mean install something? It might... it depends, ya?
I think I need to install something to make this work. but idk how I can use it on repl. @Giothecoder
@RohilPatel what’s the thing?
look up "install mysql"
@Giothecoder
I mean, I don't know how to get a database set up. @Giothecoder
@RohilPatel hm. Um.
@RohilPatel ? Yes?
I was. answering ur comment before. @Giothecoder
@RohilPatel oh lol ok. Let’s see if we can figure this out.....
@RohilPatel ok so I think I found the thing your talking about. So. I suggest instead looking for a remote sql dB.
do u have any references?
@Giothecoder
@RohilPatel maybe. If you look on repl.it I’m pretty sure they have some tutorials on how to make a remote sql dB, but for now I suggest looking up it
The "repl.it" mysql drivers are working.
One needs to work with a MySQL Server that is hosted elsewhere and it needs to permit remote connections.
Lol I asked this 12 months ago, not 12 hrs @matjung