Connect Python Script to MySQL | Railway | Page 1

stuck sun Apr 11, 2023, 5:40 AM

#

Hi there,

I am simply trying to connect a python script to a MySQL instance but I'm getting this error:
_mysql_connector.MySQLInterfaceError: Can't connect to MySQL server on 'localhost:7140' (99)
See the screenshot for my connection code.

📎 Screenshot

nocturne shadowBOT Apr 11, 2023, 5:40 AM

#

Project ID: 28e5bbc5-449a-46ba-80bd-62e16c4eed9b

#

You might find these helpful:

stuck sun Apr 11, 2023, 5:41 AM

#

Project ID: 28e5bbc5-449a-46ba-80bd-62e16c4eed9b

shell shale Apr 11, 2023, 6:17 AM

#

are you getting this error when both the python script and mysql instance are running on railway?

stuck sun Apr 11, 2023, 3:33 PM

#

yes

shell shale Apr 11, 2023, 3:44 PM

#

can you show me a screenshot of your service variables?

stuck sun Apr 11, 2023, 6:53 PM

#

#

should I reveal them?

shell shale Apr 11, 2023, 8:26 PM

#

no no, please show the service variables though, those are the plugin variables

stuck sun Apr 12, 2023, 1:25 AM

#

#

ah i see, should I be manually adding those variables here?

shell shale Apr 12, 2023, 1:26 AM

#

no never add the database variables manually, click the variable references link button, but read this before you get into that, read this

#

https://docs.railway.app/develop/variables#reference-variables

stuck sun Apr 12, 2023, 4:25 PM

#

Ok it works thanks. Another question, if I have a database table that I want to have pre-loaded without the program needing to create it, what would be a good way for me to do that? Or should I set it up in the code like: if table exists, continue, if not, create it.

shell shale Apr 13, 2023, 1:12 AM

#

stuck sun Ok it works thanks. Another question, if I have a database table that I want to ...

look into database migration

#Connect Python Script to MySQL