Lost connection to MySQL server at 'handshake: reading initial communication packet

surgeapp35HOBBY

7 months ago

My website was up and running fine, but now I am getting this error message. Can you please help me understand what the error is and how to resolve.

14 Replies

surgeapp35HOBBY

7 months ago

Here is a more detailed error:
(2013, "Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11")


7 months ago

Have you tried redeploying the database?


surgeapp35HOBBY

7 months ago

No. Will that keep my data intact?


7 months ago

Unless you have previously misconfigured something, your data will be in tact.


surgeapp35HOBBY

7 months ago

so I redeployed mySql and still getting the same error.


surgeapp35HOBBY

7 months ago

Actual error is this though: (1045, "Access denied for user 'root'@'192.168.0.179' (using password: YES)")


7 months ago

If your application is trying to connect to that IP you have your MySQL client incorrectly configured as that is not the IP of the databases, please make sure you have correctly configured your MySQL client with all the needed environment variables


surgeapp35HOBBY

7 months ago

What I don't understand is that this has been working and configured and we changed nothing on our end.

This is what we have for server port: roundhouse.proxy.rlwy.net:14447

for MYSQLHOST variable we have: roundhouse.proxy.rlwy.net

I get the same error when I try mysqlworkbench and even the CLI.

here is the error from the CLI: ERROR 1045 (28000): Access denied for user 'root'@'192.168.63.241' (using password: YES)

I am not following.


7 months ago

Please read my last message again.


surgeapp35HOBBY

7 months ago

Where do I get the information that is needed. Like I said it's been configure correctly. Not sure what is changed. I was not the one that set it up in the first place.


surgeapp35HOBBY

7 months ago

Is there a web administration console I can access the db from?


7 months ago

You would want to use reference variables for that - https://docs.railway.app/guides/variables#reference-variables

> Like I said it's been configure correctly.

Unfortunately this is not true, if you had it configured correctly, you would not be getting these errors.

> Is there a web administration console I can access the db from?

Not sure what you mean by this, there is a data tab though.


surgeapp35HOBBY

7 months ago

I understand what you are saying about not being configured correctly. Its not working because something is not configured correctly, I get that. However, what I am trying to understand is why it was working before. Did something change with Railway. The configuration hasn't changed and it was working. I am asking that so that I can know how to troubleshoot it. I am also looking at the current configuration and the reference variable information you sent to see if I see what is misconfigured. Its difficult to see what is wrong with the current configuration.

Thank You for your help.


7 months ago

There is nothing that changed with Railway that could have caused an application level issue with your code I'm sorry but we have no observability imo what your code does or doesn't do.


Lost connection to MySQL server at 'handshake: reading initial communication packet - Railway Help Station