Node.js : How to Connect with MySQL Database in Node.js

Learn How to Connect MySQL Database in Node.js.

If you like this video then Do share the video in the article to your friends or in your social media accounts. You can also subscribe to the YouTube channel.

Check out the video above to learn How to Connect with MySQL Database in Node.js

I recommend checking out Mastering Node.JS book. You can get a lot of answers to your questions. Plus the new edition of the book can cover some of the latest topics too.

How to Connect with MySQL Database in Node.js Examples

Node.js is turning out to be popular V8 engine that can help you connect your javascript apps to the popular database servers like MySQL. So here we are going to take a look at how to do just that. Video basically gives you lot more clearer steps than what I have done here in the tutorial. So I recommend you to check out the tutorial in video first.

Here we are going to use the "mysql" npm package. There are also other ORMs that you can use. Like say you can use sequelize which we will cover later if possible. So when you do the install for the mysql package. You may enter command that looks something like this.

npm install --save mysql

And that should help install the npm package in directory. In order to connect the script to the mysql database server you should add the reference for the mysql npm package like this.

var mysql = require('mysql');

And you can pass the connection parameters something like the below code.

var connection = mysql.createConnection(
{ host : 'localhost', 
user : '< MySQL username >', 
password : '< MySQL password >', 
database : '<your database name>' }
);

After this you can go ahead and do the respective manipulation of data or connect to database. I suggest you should watch the video for complete tutorial.

So that's simple demo for you to check out. I recommend checking out Mastering Node.JS book. Let me know if you like the video.

I hope the information here helps you. I'd appreciate if you like the video and share it with others.