Geek asks and answers

How to configure node-mysql?

I found many tutorials explaining how to install "node-mysql" (basically: "npm install mysql" and what it is) and others explaining how to make queries, but nothing in between.

I mean: without a GUI, how do you configure node-mysql (username Mysql, password Mysql, first table, ..) before using it?

OR: How to install a GUI to access node-mysql for release (to solve problem 1)?

I tried the "Mysql Workbench" through its wizard, but I get the message "Can not connect to Database Server", while the host and port are fine. I searched the MySQL Workbench site, but said nothing about node-mysql.

Node-mysql seems to be the first choice when it comes to using mysql with node.js, but surprisingly, there is nothing in my problems.

Thank you for your help.

+3
source share
1 answer

you do not need to configure node -mysql yourself, you need to learn how to add users to the mysql database .

If you already have an existing user, the node-mysql client is very easy to use:

var client = mysql.createClient({
  user: 'someusername',
  password: 'somepassword',
});
0
source

More articles:


All Articles