I am trying to connect to the mysql database from my express server in cpanel (the databse and server are both in cpanel) , I already added a user, and I'm trying to connect via localhost but this ain't working below is the code:
const db = mysql.createPool({
host: "localhost",
user: \\user\\,
password: \\password\\,
database: "ts34mpr_SCMP",
dateStrings: true,
});
The request isn't reaching the databse although I added the user with all privileges and the user with password are 100% correct. Any help please? Thank you!
Try this:
const mysql = require('mysql');
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '',
database: 'cpanel'
});