heres who to deploy go + mysql on railway:

quick steps:

1. add mysql database to your project (click + new → database → mysql)

2. deploy your go app from github repo (+ new → github repo). railway auto-detects go projects from go.mod

3. super important , make sure your go app listens on railway's PORT variable:

go

port := os.Getenv("PORT")
if port == "" {
    port = "8080"
}
http.ListenAndServe(":"+port, handler)

4. connect to mysql using the env variables railway gives you automatically. in your go app use:

go

dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s",
    os.Getenv("MYSQLUSER"),
    os.Getenv("MYSQLPASSWORD"),
    os.Getenv("MYSQLHOST"),
    os.Getenv("MYSQLPORT"),
    os.Getenv("MYSQLDATABASE"),
)

5. in your go service settings → variables tab, reference the mysql service variables

6. generate domain under settings → networking

your html/js frontend just needs to be served by your go app and it'll deploy together. the PORT thing catches most people , railway assigns a random port so you gotta use their variable.

lmk if you hit any snags, happy to help further!

Thank you very much, I managed to solve it.