a month ago
Can't connect to database. See attached print.
Pinned Solution
a month ago
I think I'd try creating a completely new MySQL instance in your dev environment...
8 Replies
a month ago
Cannot see any attachedments on this post tho
a month ago
Are you able to connect to the database via a SQL client (eg, Datagrip) through the public URL credentials?
a month ago
No, I am unable to connect to the MySQL 9.4 database via SQL client using the public URL credentials.
Error received:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Tested with:
- MySQL CLI client (mysql command)
- Railway DB UI (also fails with same error)
Interesting finding: MySQL logs show ZERO failed connection attempts, suggesting the error occurs at the Railway proxy/SSH layer before reaching MySQL itself.
MySQL version: 9.4 (uses caching_sha2_password by default)
Maybe authentication plugin incompatibility between MySQL 9.4 and Railway's connection proxy???
a month ago
I am able to connect to the Production database via SQL client using the public URL credentials.
Connection successful with: - MySQL CLI client - Application backend - Railway DB UI
This environment works perfectly, while Development (MySQL 9.4) does not.
a month ago
I think I'd try creating a completely new MySQL instance in your dev environment...
a month ago
It worked! This is the only way it works. I couldn't find any other way. Thank you!
Status changed to Solved passos • 29 days ago
