Database Connection Using Node.js and MYSQL

From this article you will get to know how to create a database connection in Node.js.



Before creating the database connection you should have installed MYSQL on your computer.
Go to your project folder and create a file called connection .js. Then copy the following code into it.

 var mysql = require('mysql');
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: ""
});
con.connect(function(err) {
  if (err) throw err;
  console.log("Connected successfully!");
  con.query("CREATE DATABASE nodedb", function (err, result) {
    if (err) throw err;
    console.log("Database is successfully created");
  });
});

Here the database which is known as nodedb will be created in the code itself. If there is no any error it will gives the output of 

"Connected successfully!"
" Database is successfully Created "

 if not command line will display the error.

Now run the file in the project.Hope to see you soon with more articles on Node.js.




Comments

Post a Comment

Popular posts from this blog

Angular2 Popup Modal Window

Image
Popup Modals are nowadays come in to play in a handy way which can be seen in most of the modern web applications. These Popup modals are usually come as a form, as confirmation message or can be used for many other activities in the web application. Though creating a Popup  modal is not a very big deal this article will help you to get to know how to create a popup model  in Angular. Go to your Angular project folder and you should import Popup library to your project. npm install ng2-opd-popup --save Now run the project. Now copy the following import code from the npm guide  and paste it in app.module.ts import   { PopupModule }   from   ' ng2-opd-popup ' ; Also you have to paste PopupModule . forRoot ( ) inside the imports in the same file. import { BrowserModule } from '@angular/platform-browser'; import { NgModule } from '@angular/core'; import { FormsModule } from '@angular/forms'; import { HttpModule } from '@angular/http...
Read more

Java Part 3 : Creating a New Project in Java

Image
Before Developing a program you will have to create  a new project using Netbeans. For that you will have to follow the steps given below. Step 1 : Click file menu and open New project Here the category should be Java and the project should be Java Application as shown in the image shown above. Then click Next . Step 2 : Give a suitable name for the project Here I have named the project as MyProject . Also you can select the location to save the project. and then click finish. Now the project has been created and it will be displayed in the side menu bar. Now you can start coding .
Read more