I created 3 tables on mySQL database in railway instead of creating on MySQL server and deploying on railway. THe problem imm facing is that I cant connect to my database through node js anymore.
const connection = mysql.createConnection({
host: 'monorail.proxy.rlwy.net',
user: 'root',
password: '', port:
});
even after entering all details properly this is the error message i received on my terminal
code: 'ERNOTSUPPORTEDAUTHMODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true

how do i resolve this