I have a perl program that uses the same environment variables as my groovy code below and successfully displays the result from gov_unit.
So I know that the server is running, the IP address is correct, the table name and database name are correct and the user name/password are correct. However, when I run the following groovy program
it throws the exception:
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 10 times. Giving up.
I'm using groovy console 4.0.0.-alpha 1. Switching to Groovy 3.0.4 or 3.0.2 yields the same results...
I'm using Windows MySQL server 8.0.17-winx64 which was unzipped (instead of installed).
I could not find any config files like my.ini to experiment with changing the bind address.... However, since perl works, this should not be a problem.