How to Connect Node.js Application to MySQL?
Asynchronous Node.js database connection example using mysql2/promise driver.
SQL Query Statement
const mysql = require('mysql2/promise');
async function connectDatabase() {
try {
const connection = await mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'your_password',
database: 'company_db'
});
console.log('Connected to MySQL via Node.js async/await!');
const [rows] = await connection.execute('SELECT 1 + 1 AS result');
console.log('Query Test Result:', rows[0].result);
await connection.end();
} catch (error) {
console.error('Database connection error:', error.message);
}
}
connectDatabase();Expected Result / Output
Connected to MySQL via Node.js async/await! Query Test Result: 2