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, Oct 05 '13 at 08:41

score 1 · Answer 1 · answered Oct 05 '13 at 08:31

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 05 '13 at 08:31

Dmitry Matveev

5,320
1
32
43

score 0 · Answer 2 · edited May 23 '17 at 12:33

 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

In nodejs with MySQL

2 Answers2