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 about 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 about 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 about 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 about 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 about 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 about 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 about 1 year ago


Status changed to Solved brody about 1 year ago


Loading...