Shulou(Shulou.com)06/01 Report--

How to connect Node.js to MySQL? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Node.js is a popular programming language, such as PHP and JAVA for Web applications. MySQL is also the most popular database for storing values. The MySQL database driver for Node.js is available under the NPM repository.

Step 1: install the Node.js MySQL module

The MySQL driver for node.js is available under Node package Manager (NPM). Use the following command to install the node.js MySQL driver on the system.

$sudo npm install mysql

Step 2:node.js program example

The following is an example of a node.js program that connects a node.js application to a mysql server. It displays success and error messages based on the connection results and closes the connection at the end of the program. Create a javascript file, app.js.

$cd myApp$ vim app.js

And add the following to the above file.

Var mysql = require ('mysql'); var dbconn = mysql.createConnection ({host:' localhost', user:', password:'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.