I have a node.js back-end with Express and a native React front-end. The problem is that when I run a query from my front end, it gives me an error message saying Axios Network Failed. So I can’t connect my back to my front. However I have put the permissions of the cors (see below):
const express = require('express');
const cors = require('cors');
const app = express();
app.use(cors());
const mysql = require('mysql');
const db = mysql.createConnection({
host: 'localhost',
user: '***',
password: '***',
database: '***',
});
app.use(express.json());
app.get('/users', (req, res) => {
db.connect(function (err) {
if (err) {
throw err;
}
console.log('Connecté à la base de données MySQL!');
db.query('SELECT * FROM users', function (err, result) {
if (err) {
throw err;
}
res.send(result);
});
});
});
app.post('/login', function (request, response) {
let login = request.body.login;
let mdp = request.body.mdp;
if (login && mdp) {
db.query(
'SELECT * FROM users WHERE login = ? AND mdp = ?',
[login, mdp],
function (error, results, fields) {
if (error) {
throw error;
}
if (results.length > 0) {
response.send(login);
} else {
response.status(404).send('Incorrect Username and/or Password!');
}
response.end();
},
);
} else {
response.status(404).send('Please enter Username and Password!');
response.end();
}
});
app.listen(8080, () => {
console.log("Serveur à l'écoute");
});
Here is my request in my front-end :
const submit = async () => {
if (!pseudo.trim() || !password.trim()) {
alert('Nom ou mot de passe invalide');
return;
}
const data = {
login: pseudo,
mdp: password,
};
try {
const response = await axios.post(`${baseUrl}/login`, data);
if (response.status === 200) {
alert(`Vous êtes connecté en tant que ${pseudo} `);
}
} catch (e) {
console.log(e);
}
};
If anyone has the solution, I’m a taker, thank you!

