not able to connect to mysql database created in railway through node js
subhojeet-chakraborty
TRIALOP

2 years ago

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: 'ER_NOT_SUPPORTED_AUTH_MODE',

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

1 Replies

2 years ago

Please make sure you are using mysql2.


Welcome!

Sign in to your Railway account to join the conversation.

Loading...