Google App Script - MySql 8 - JDBC Connection Fail

2019-07-25 16:09发布

问题:

I'm trying to connect to a self-hosted MySql 8 instance from a Google AdWords Script (effectively an App Script) using the Jdbc utility over SSL. My code follows the specifications in these answers here and here.

No matter what I do, I still get the following error: ERROR: Failed to establish a database connection. Check connection string, username and password.

回答1:

It turns out that the Jdbc utility only works with versions of MySql up to 5.7.

I thought I would post this here posthumously in case I can save someone else time.