5 months ago
Can't connect to database. See attached print.
Pinned Solution
5 months ago
I think I'd try creating a completely new MySQL instance in your dev environment...
8 Replies
5 months ago
Cannot see any attachedments on this post tho
5 months ago
Are you able to connect to the database via a SQL client (eg, Datagrip) through the public URL credentials?
5 months 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???
5 months 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.
5 months ago
I think I'd try creating a completely new MySQL instance in your dev environment...
5 months ago
It worked! This is the only way it works. I couldn't find any other way. Thank you!
Status changed to Solved passos • 5 months ago
