The examples for connecting to external databases are primarily showing connection to Postgres databases, however, I understand the connection to MySql should be very similar. Per my previous post, I have tried executing the exact code from the single Mysql example - to no avail. I have tested my credentials, etc., from MySQLWorkbench and it connects just fine, so I believe it safe to assume that is not the problem.
MySQLWorkbench is hitting the external database with my client IP address, which is in that machine’s whitelist. pysql is not available on the client, so I assume when my anvil server code executes, it’s trying to connect to the external database from the anvil server’s IP address… .which we have also added to the external database’s whitelist
At this juncture I am out of options and dead in the water with what to try next. ANY ideas are welcomed.