Hey there! We've found the following might help you get unblocked faster:

• 📚 Using the Database View

• 🧵 postgres can't login with new create user

• 🧵 SQL Query

If you find the answer from one of these, please let us know by solving the thread!

just use Railway's Query Tab:

1. Go to your Railway dashboard and click on your MySQL thing

2. Hit the "Data" or "Query" tab at the top

3. Copy your whole SQL script from MySQL Workbench and paste it in there

4. Hit "Execute"

That's it! Your tables should show up right away.

If it gives you errors:

Just delete these sql lines from your script (you don't need them):

SET @OLD_SQL_MODE=@@SQL_MODE...
SET SQL_MODE=...
-- Basically any SET stuff at the top

only keep the CREATE TABLE parts and run that.

And complementing the reply from bytekeim, you can also connect to your Railway DB using the MySQL Workbench.
You can get the public url and credentials from the Variables tab in your database service!

where?
Hit the "Data" or "Query" tab at the top

look at the top right - there's a purple "Connect" button. click that!

It'll give you options to:

1. Use the built-in Query interface (this is what you want for running your sql script)

2. Or get connection details to use with MySQL Workbench

once you click Connect and choose the query option, you'll be able to paste your sql script directly and execute it

I tried but not working

go to your Railway MySQL service → Variables tab → copy the MYSQL_ROOT_PASSWORD → paste it in MySQL Workbench's password field → test connection

both are with different host name and port

ah yeah, you're using 127.0.0.1 (localhost) in the screenshot - that won't work because Railway's database isn't on your local machine!

ou need to use the exact hostname and port from Railway:

hostname: shortline.proxy.rlwy.net

port: 48493

username: root

password: (get this from Railway's Variables tab - the MYSQL_ROOT_PASSWORD)

But honestly bro, just use Railway's built-in Query tool - click that "Connect" button in Railway, choose Query, and paste your SQL script there. Way easier than fighting with MySQL Workbench for this!

lmk what you did

I tried both I gave both screenshot and railway's built-in query tool I can't see whenever I click on the Connect button this Shows up

Oh I see what's happening! railway is showing you how to connect from your application code, not giving you a query tool.

here's what you need to do:

then you have to use MySQL Workbench

for MySQL Workbench to work:

1. in Railway, go to your MySQL service → Variables tab

2. look for MYSQL_ROOT_PASSWORD - click the eye icon to reveal the actual password

3. copy that password

4. go back to MySQL Workbench

5. click "Store in Vault..." button in the password field

6. paste the password you just copied

7. clik Test Connection

the key is you need to actually PASTE the password into the vault - just having the field say "Store in Vault..." means it's empty

this is what I'm getting

use the Public Network connection instead

go back to Railway → Click Connect → Switch to "Public Network" tab

copy those connection details (they might be different)

use those in MySQL Workbench instead

same

ok i will give you the last 2 thing to do then i will give up hhhhhh but u don't give up hhhh

first :

in MySQL Workbench, go to the "SSL" tab (next to Parameters)

set "Use SSL" to "If available" or "No"

try connecting again

if it doesnt work :

try Railway CLI instead (easiest tbh)

Open your terminal/command prompt and run:

railway login

railway link

railway connect MySQL

this will connect you directly and you can run your SQL script from there.

lmk know the result