In nodejs with MySQL

Question

I am Using Nodejs with MySQL.

But problem is that My MYSQL Connection Password Able to see in browser, With this any user get my my SQL username and Password.

Is it possible no one can see my MySQL Connection permanent as its is a server side.

Can any one help me in this.

Add in some code.. or the URL to the web page that you are developing.. — Abhishek Punj
– Abhishek Punj, Commented Oct 5, 2013 at 8:41

Dmitry Matveev · Accepted Answer · 2013-10-05 08:31:04Z

1

Do not send you password to client but store it in a variable inside your server-side script. On a request, use it to access database and send only the result of the operation.

If you show your code you might get a more detailed answer then this...

answered Oct 5, 2013 at 8:31

Dmitry Matveev

5,3661 gold badge34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:33:44Z

0

 var connection = mysql.createConnection({
   host     : 'host',
   user     : 'dbuser',
   password : "pword",
   database : 'database',
 });

 connection.connect();

 connection.query(etc etc etc)

for full example see mysql module in node.js not works in my case

or another way is to save the configuration and password details in either an env file or other file (or even sqlite db file and load it on startup/restart of your script

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Oct 23, 2013 at 22:45

lxx

1,35421 silver badges31 bronze badges

Collectives™ on Stack Overflow

In nodejs with MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related