Can I connect to my Railway MySQL in jupyter lab with python?

I'm trying to get the data from my MySQL db into a csv and analyze it. Can't find a resource to do so. I tried installing mysql-connector-python and using import mysql.connector and using db = mysql.connector.connect( host = " ", user = " ", password = "" ) but it keeps saying Can't connect to MySQL server on "...railway.app"
Solution:
you would either need to use the database url variable, or all all the other environment variables available for your database
Jump to solution
5 Replies
Percy
Percy13mo ago
Project ID: N/A
Hosna Qasmei
Hosna Qasmei13mo ago
N/A
Solution
Brody
Brody13mo ago
you would either need to use the database url variable, or all all the other environment variables available for your database
Hosna Qasmei
Hosna Qasmei13mo ago
ah okay gotcha let me try it yay cool it works, I just needed to add port and database thank you!
Brody
Brody13mo ago
no problem!
Want results from more Discord servers?
Add your server