Using the MySQL connection pool:
1. Install MySQL support
NPM install MySQL
2. Install the node. JS Mysqlpool Module
NPM install-g node-mysql//-g Table Global
3. Direct connection to MySQL
var mysql = require (' mysql '); Call the MySQL module
Create a connection
var connection = Mysql.createconnection ({
Host: ' localhost ',//Hosts
User: ' Root ',//mysql authenticated username
Password: ' Root ',//mysql authenticated user password
Database: ' MyDB ',
Port: ' 3306 '//port number
});
Create a connection
Connection.connect (function (err) {
if (err) {
Console.log (' [query]-: ' +err ');
Return
}
Console.log (' [Connection connect] succeed! ');
});
Execute SQL statement
Connection.query (' SELECT * from users ', function (err, rows, fields) {
if (err) {
Console.log (' [query]-: ' +err ');
Return
}
Console.log (' The solution is: ', rows[0].email);
});
Close connection
Connection.end (function (err) {
if (err) {
Return
}
Console.log (' [Connection end] succeed! ');
});
Nodejs link MySQL