MySQL Database connection from node js application from Techmirrors.org

In This video I have shown how to connect MySQL database from node js Application.

1. create node project “npm init -y”
2. install mysql package “npm install mysql”
3. create a file like “database.js”
4. import mysql package “const { createPool } = require(‘mysql’)”
5. create pool connection
—————————————–
const pool = createPool({
host: “localhost”,
user: “root”,
password: “”,
database: “test”,
connectionLimit: 10
})
6. execute query
—————————
pool.query(`select * from registration`, function(err, result, fields) {
if (err) {
return console.log(err);
}
return console.log(result);
})

sourceTechmirrors

Read More: