SQL injection is a common vulnerability allowing attackers t…
SQL injection is a common vulnerability allowing attackers to manipulate a database by injecting malicious SQL code into input fields. Below is a piece of JavaScript code that interacts with a MySQL database using user input. Unfortunately, this code is vulnerable to SQL injection. const express = require(‘express’); const mysql = require(‘mysql2’); const app = express(); const port = 3000; const connection = mysql.createConnection({ host: ‘localhost’, user: ‘root’, password: ‘password123’, database: ‘user_database’ }); app.use(express.json()); app.post(‘/getUser’, (req, res) => { const username = req.body.username; const query = `SELECT * FROM users WHERE username = ‘${username}’`; connection.query(query, (error, results) => { if (error) { res.status(500).send(‘Database error’); return; } res.json(results); }); }); app.listen(port, () => { console.log(`App listening at http://localhost:${port}`); }); Database Name: user_database Tables: users (columns: id, username, password) admin_logs (columns: log_id, admin_action, timestamp) Question: Explain why the provided JavaScript code is vulnerable to SQL injection. Describe the specific part of the code that leads to this vulnerability (It is required to cite how the exploitation happens line-by-line) (10 points). Provide an example of a malicious input that an attacker could send to the /getUser endpoint to retrieve all entries from the admin_logs table (the input must work) (10 points).
Read Details