3 months ago
Hi Railway Team,
I’ve been using a MySQL service on Railway for a while and it was working perfectly via both my project and external tools like DBeaver. However, recently I’m unable to connect at all — getting the error:
```ERROR 1045 (28000): Access denied for user 'root'@'my.ip.address'```
I haven’t changed anything in the configuration. Could you please confirm if:
Public/external access to MySQL has been disabled?
There’s any change in allowed IPs or connection policies?
Also, if railway connect is now the only way to access the DB, is there a way to use it in production environments where CLI tunneling isn't feasible?
Appreciate any help!
6 Replies
3 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
3 months ago
Heya, this looks like an issue with your mysql instance (not on our end), you may want to check and ensure outside connections are enabled. The "denied" error shows you're able to reach mysql, but it's not accepting your creds.
Status changed to Awaiting User Response Railway • 3 months ago
itsrems
Heya, this looks like an issue with your mysql instance (not on our end), you may want to check and ensure outside connections are enabled. The "denied" error shows you're able to reach mysql, but it's not accepting your creds.
3 months ago
Not sure how to do that since I created the database in Railway. I don't know how I can change network settings or update permissions.
This was previously working database, not sure how outside connections are disabled automatically.
This is the project ID: 24279e9b-867f-49ab-91c4-fb5994b54a0c
Status changed to Awaiting Railway Response Railway • 3 months ago
3 months ago
It appears you may have changed your credentials. You'll want to update them in the environment variables
Status changed to Awaiting User Response Railway • 3 months ago
jake
It appears you may have changed your credentials. You'll want to update them in the environment variables
3 months ago
No changes from our side were made to the container. I don't think we can change credentials without connecting to container?
Can you please help me here? This is production database and is down from so long.
Status changed to Awaiting Railway Response Railway • 3 months ago
3 months ago
You'll want to:
Take the password from the environment variables
SSH into the box
Set the password to the one from the credentials
Status changed to Awaiting User Response Railway • 3 months ago
2 months ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • 2 months ago