Wednesday, 7 June 2017

How to connect to remote hostinger mysql server in node js?

Am making a electron desktop app for fetching exam results which will be displayed as a table(am stating this because i don't want to use 'grant permission' query in sql means this app will be used by many students not just me)

i tried below code am getting ENOTFOUND getaddrinfo mysql.hostinger.in error.

can it be solved by any npm package?if not please provide the code.Thanks

//code

var mysql = require('mysql');

note:fake parameters were given

var conn= mysql.createConnection({

host: "remote_host",

user: "MJ",

password: "This*is*it",

database: "POP"
});

conn.connect((err)=>{

if(err)
  return console.log(err.stack);

 console.log("remote connection successfull");

});



via michael jackson

No comments:

Post a Comment