a year ago
From my local machine, I'm trying to push my MySQL schema to Railway (still on trail mode).
For my connection string, I'm using the MYSQL_URL provided by Railway in the Variables section of my Railway created database.
When using "prisma db push" locally I get an auth error:
Error: P1000: Authentication failed against database server at [monorail.proxy.rlwy.net](monorail.proxy.rlwy.net), the provided database credentials for MyUsername are not valid.
As I'm just using the credentials provided by Railway I'm wondering what's going on.
Any help would be great, thanks!
3 Replies
a year ago
I think this happens when you try to edit some of the Variables in Railway. I.e. changing away from MYSQLUSER: root and MYSQLDATABASE: railway as that seems too standard. After you change, you always get auth errors - even after those changes are Deployed.
a year ago
I deleted this database and created a new one, kept everything standard and I can connect now. Seems a bit awkward.
a year ago
you are correct, those variables are only used to set the username, password, and database on the first deployment, changing them after the fact does not sync the changes to the database. this is not Railway behavior but instead just how MySQL's docker image works.
Status changed to Solved railway[bot] • about 1 year ago