i cant connect to my mysql database
victormanuel4
TRIALOP

a year ago

when i try to create a new table from railway web the only thing that shows is this

Deployment Online

This service has an active deployment

  • Required Variables This service has all the necessary variables that this UI uses to connect to the database.
  • Database Connection

and it gets stuck in database connection

i tried also to connect directly from mysql tools to modify the db from there but i cant connect from those either

Solved

8 Replies

a year ago

Hello,

Have you changed the username or password of the database since deploying?


Status changed to Awaiting User Response Railway over 1 year ago


brody

Hello, Have you changed the username or password of the database since deploying?

victormanuel4
TRIALOP

a year ago

uhh no, gonna change it just in case, i just create the database from railway itself, or idk if u are refering to not to change anything


Status changed to Awaiting Railway Response Railway over 1 year ago


a year ago

Hello,

I was not suggesting to change anything, was just a question.

But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username.

Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it.

Best,

Brody


Status changed to Awaiting User Response Railway over 1 year ago


brody

Hello, I was not suggesting to change anything, was just a question. But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username. Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it. Best, Brody

victormanuel4
TRIALOP

a year ago

yeah, in my case i dont modify anything

i just create the database from railwail itself

w/o changing anything

i created other and still nothing


Status changed to Awaiting Railway Response Railway over 1 year ago


brody

Hello, I was not suggesting to change anything, was just a question. But it is clear that you have changed something as the connection attempts are failing because of an incorrect password or username. Since I don't know what you have done to the databases, I would have to recommend deploying MySQL again and to not modify anything with it. Best, Brody

victormanuel4
TRIALOP

a year ago

ah yeah, i created another project and now it works

but now i just see this

Deployment Online

This service has an active deployment

  • Required Variables This service has all the necessary variables that this UI uses to connect to the database.
  • Database Connection We are unable to connect to the database over the public network. Can you connect using this command?
mysql -hroundhouse.proxy.rlwy.net -uroot -p******** --port 18142 --protocol=TCP railway  

at least i can modify from an sql editor but i sometimes want to watch directly from the railway ui


a year ago

The data tab is working fine for me?


Status changed to Awaiting User Response Railway over 1 year ago


brody

The data tab is working fine for me?

victormanuel4
TRIALOP

a year ago

strange, for me is like this

Attachments


Status changed to Awaiting Railway Response Railway over 1 year ago


a year ago

Okay you left out the crucial information that you only get that error when you open the table.

Your schema for that table would generally be considered invalid, it is missing an index, so the data tab is unable to display it properly.

There are 3rd party software such as DbGate that are far more lenient on what is a valid data model, so please use DbGate instead.

Best,

Brody


Status changed to Awaiting User Response Railway over 1 year ago


Status changed to Solved brody over 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...