Jin's Blog

[Node.js] How to get connection with MySQL

August 10, 2017 | 0 Minute Read

This post is based on my personal experiences.

prerequisite

  1. npm install mysql

here is the sample codes


var mysql = require('mysql') // declear MySQL connection
var con = mysql.createConnection({
  host: "db Address",
  user: "write db ID",
  password: "write db Password"

  });

  con.connect(function(err) {
    if(err) throw err;
    consoloe.log("DB Connection worked");
    con.query("Write your own query", function(err, output){
      if(err) throw err;
      console.log("Query worked");

      });


  });