How do I view my database's my.cnf file?
dustyhansen
PROOP

8 months ago

I am being asked to provide the contents of this file to a developer to troubleshoot an issue. I am not clear on how I would access this file since I cannot ssh into the server.

I tried creating a file browser deployment and mounting a backup volume to it, but the file is not on that volume.

$10 Bounty

4 Replies

x-lem
HOBBY

8 months ago

You can SSH into your db instance

bash <(curl -fsSL cli.new)
railway login
railway link
railway ssh

The railway link command will have you select a project/service (just select your db service).

Taken from: https://blog.railway.com/p/ssh

sim
FREE

7 months ago

Once you set up the Railway CLI you can also simply right click the database and there is an option to "Copy SSH Command"

sim
FREE

7 months ago

As for the location of the file this resource may help https://serverfault.com/questions/346647/mysql-wheres-the-my-cnf-path

If it does not help let me know and I can troubleshoot more with you

dustyhansen
PROOP

7 months ago

i have tried both ways and it refuses to connect. Just times out after 3 attempts.

Loading...