Hi C9 community, I need some help regarding establishing an ODBC connection between my Windows Computer using the MySQL ODBC Connector and the current database I am running. I have a running MySQL database working with my app, and I now need to create an ODBC connection to connect said database to another database software on my computer. However, I am having issues establishing a connection when entering the TCP/IP Server field.
I have tried running curl ipinfo(dot)io in the terminal and using the ip address given, as well as the general site root path (xxx.remyc95.c9users.io) but cannot establish a connection with my current user I have created and am able to work with in phpmyadmin.
What should I be looking for when entering the TCP/IP Server field? Do C9 databases support ODBC connections to its databases?
Edit: Error produced is “Lost connection to MySQL server at 'reading initial communication packet, system error: 0”
Thanks in advance.