JDBC Connection

[Guy Thomas]

So I am attempting to connect to MySql version 8 using a Google App Script.
I can connect to the Database with various other means without a problem.
Using a script - it fails to connect every time... two other IT professionals of my acquaintance have been involved with me on this now and still cant get it working...

NOTE: My Windows firewall software is configured to allow ALL connections via port 3306.

I note in the Workbench under Server variables/ Networking Stats... each time I run the script to connect to the database.. I see 'Connections' and 'Aborted_Connects' increment by one each time. Where can I interrogate the logs to find out EXACTLY why the connections are being aborted...?


In an attempt to get this working I have set the following in My.INI :

skip-name-resolve
port = 3306
mysql_firewall_mode = off

If I check the Server log I see with each connection attempt:
'IP Address__.__.__.__ could not be resolved. No such host is known'

1) Given that I have 'skip-name-resolve' stated in the .ini file, why am I seeing this error?

I have cleared the LOG file, restarted the service and attempted to connect 3x times... log is shown below.. does this give anyone any ideas why I am having all this trouble...?? Thanks in advance for any help you can give. I am desperate to get this working (and running out of time...)


2018-11-21T09:12:07.946772Z 0 [Warning] [MY-000076] [Server] option 'shared_memory': boolean value '' was not recognized. Set to OFF.

2018-11-21T09:12:07.946916Z 0 [Warning] [MY-000081] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192.

2018-11-21T09:12:07.946939Z 0 [Warning] [MY-000081] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1.

2018-11-21T09:12:07.947126Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2018-11-21T09:12:07.953788Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.13) starting as process 2976

2018-11-21T09:12:11.865322Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2018-11-21T09:12:12.012564Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.13' socket: '' port: 3306 MySQL Community Server - GPL.

2018-11-21T09:12:12.053318Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

2018-11-21T09:12:30.458575Z 8 [Warning] [MY-010055] [Server] IP address '173.194.100.162' could not be resolved: No such host is known.

2018-11-21T09:12:32.945671Z 9 [Warning] [MY-010055] [Server] IP address '173.194.100.97' could not be resolved: No such host is known.

2018-11-21T09:12:35.247980Z 10 [Warning] [MY-010055] [Server] IP address '173.194.100.164' could not be resolved: No such host is known.