Thank you for confirming the issue as from either host, @Scott Fergusson . There are two steps to work towards resolving this issue and they include:
- Enable redirect on your Azure Database for MySQL instance. This will bypass the gateway host in the region for which your service is deployed, after authentication has been established. All client <> server traffic is direct without a gateway serving the requests. Please see: Connect to Azure Database for MySQL with redirection
- The second item is leveraging Azure Monitor for data platform to either: a) further troubleshoot connectivity issues, or b) identify incremental gains at the query level through Query Performance Insight (Applies to: Azure Database for MySQL 5.7, 8.0).