Swordgeo π
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
I'm not sure what my project id is. My link is this:
https://railway.app/project/31b9ee92-06cc-44c1-b7ac-f0e1ce21e2f1
So basically I'm using this database to serve my website. I released to production and I was having issues where the connections would drop from inactivity after a few minutes. Consulting ChatGPT, it said a dirty fix would be a periodic ping of the database to keep the connection going, so I set on up on a 2 minute timer.
This worked for a day or two perhaps, before the database wouldn't allow a connection, either from production environment or even locally or from MySQL Workbench.
I hopped on the Railway website, hit "restart database", and everything was fine, for another day.
Now I am unable to connect to the database in any way, even when I attempt to restart the database again.
I'm inexperienced with this kind of thing and would appreciate help from those wiser than I.
24 replies