this is mysql

not sure what you mean by "I created a pooling "

const db = mysql.createPool({

I don;t know what it means before I just used a single connection.

const db = mysql.createConnection({
host: process.env.DBHOST, user: process.env.DBUSER,
password: process.env.DBPASSWORD, database: process.env.DBDATABASE
});

are you using the private network to connect to the database

i uploaded my sql file to railay

anytime I add port my app doesn't deploy so I don't put the port railway provided

I don't think so im not sure

please use the private network to connect to your database

What is that? The tables are on railway I set the environment vars app deploys I can see my webapp pages but anytime I query database to login i get the handsake error or my error handling logs are caught.

I looked in mysql the private network seems to be enabled but not sure what that would be used for for this instance.

use the private domain and port to connect to the database