NodeJS + MySQL Database Connection Tutorial

Learn how to do NodeJS + ExpressJS + MySQL database connection using XAMPP as MySQL database and querying data from database.

If you found the video valuable, please leave a like and subscribe ❤️ It helps the channel grow and helps me pumping out more such content.

About Me:
I'm a CSE'21 graduate from BITS Pilani, Goa. I started coding early in life, at the age of 13 when I created my first blog on Blogger. I am listed in Google, Microsoft, Sony, eSet, etc. Hall of Fame for reporting vulnerabilities in their systems.
I am Apple's WWDC'19 Scholar - visited San Fransisco and attended WWDC. Currently working on my own startup - codedamn.

Connect with me:

[davidnouvellon]

FINALLY something interesting ABOUT connecting MySQL to JS

[mahtabalam]

I'm really liking these Node tutorials man! Thanks again for your hard work and hope to see some more videos :). It would be good if you could show how to use some of the popular modules in node (passport, stripe, etc.)

[UmaMaheshBhamidipati]

Really working hard to learn node...You are making simpler thank you mehul great

[jojojawjaw]

THANK YOU SO MUCH!! awesome tutorial, life saver

[amdeek]

I thank Christ for you. I went months trying to get a database connected with node or PHP and I always came close but things would break. Thank you. Thank you sir.

I know this is probably simple, but this wasn't working for months.

[undercrackers]

Thank you for the database pooling instruction.

[soultouchingsongs]

Excellent.. You made it easy. Thank you👍

[keivansf]

Thanks a lot man! It was truly helpful for me!

[musiclovers]

Truly awesome!!
Simply awesome
Amazing 😉 thanks a lot

[supakorniamsrisuwan]

thank you, your tutorial is really useful.

[AnilKumar-fwme]

Thanks for tutorial.It would be helpful for me

[edoc-code]

Thank you very much, i have an idea now how to connect my database to my nodejs project

[luisenaguero]

Hello ! Nice tutorial.

Im new using NodeJS and I have this couple of doubts:

Once I make the connection with the db ( connection.connect(); ) In my conf.js file, this connection can be used in other files using " module.exports = connection; " ?

That being said, I have another question:

I'm used to work with CodeIgniter as an API, where the connection to the MySQL lives only during each request. In this case, taking in count that NodeJS should "be on" the whole time, is it bad to have a non stop living connection ? How does this work ?

Thanks !

[reggy]

Thanks for the tuts. I am trying out custom pages for pre made js websites. Atleasti know what im looking for when linking dbs now. Just need to learn how to make a new page work without it saying cant get x page

[skandahle]

I came expecting to learn what's in the title, but left with a bonus: shift+right click in Explorer gives mes "Open command window here". Thanks!

[coolNotCold]

Could you please upload a video how I will transfer these data from node js to angularjs ?I am different background so I do not have strong knowledge on it.

[Billywong]

hi. do you already have a .db file before you start typing all these scripts?
if I do not have a .db file then can I create one ? (by modifying your scripts?)
cheers

[alithejumbo]

Couldn't you ask whoever is hammering wood in the background to stop a bit? Thanks anyway!

[seunzone]

Thanks for this...Lets say I have built a node app and using MySql working fine with it. Is it possible to host this app on an apache server like GoDaddy hosting platforms?

[yashmehta]

hey can you show an example of react instead of express framework. Thanks