MySQL connection error
marketing717
PROOP

a month ago

Can't connect to database. See attached print.

Solved$10 Bounty

Pinned Solution

I think I'd try creating a completely new MySQL instance in your dev environment...

8 Replies

Can you resend the image?


phukon
HOBBY

a month ago

Cannot see any attachedments on this post tho


marketing717
PROOP

a month ago

There it's. Thanks!

Attachments


Are you able to connect to the database via a SQL client (eg, Datagrip) through the public URL credentials?


marketing717
PROOP

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???


marketing717
PROOP

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.


I think I'd try creating a completely new MySQL instance in your dev environment...


marketing717
PROOP

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


Loading...